{"text_format":"1","workbook":"xlsx","n_sheets":35,"sheets":["Start","Straw","Rape straw","Meadow grass","Beets","Maize","Ley","Results Ley","Clover max periode","Clover","Result Clover","Results -straw","Results rape straw","Results  meadow grass","Results beets","Results Maize","Transport","Straw print","Rape print","meadow grass print","Beet print","Normer","Tabels","Raw data Beets","Cases Eng","Ark1","Raw Clover 3 cut","Raw data Ley","Raw Clover","Raw data Maize","Bulk Density Tables ","Silage loss","transporteksempler","Ark2","Beregnignsark"],"not_rendered":{"charts":6,"images":8,"macros":1,"external_links":3,"defined_names":342,"comments":21,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Main menu"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"2015-10-07","Modellen er under forandring, da den fremover kun skal behandle biomasserne hen til lågen. Der tilføjes en model der behandler biomassen på anlægget og en der håndterer biomasen efter afgasning"]

{"sheet":"Straw","index":1,"n_rows":53,"n_cols":37,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,1,49,2],[52,1,52,2],[50,1,50,2],[57,1,57,2],[58,1,58,2],[5,14,5,15],[13,14,13,15],[1,13,1,16],[0,13,0,16],[1,19,1,22]]}
["Entry for straw"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Facility",null,null,null,null,null,"Entries for decentral briquetting",null,null,null,null,null,null,null,null,null,null,null,null,2]
["Yield",null,null,null,null,null,null,"Storage",null,null,null,null,null,"Pretreatment, facility",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Yield",null,{"$f":"CultivatedArea*Yieldperha","v":676},"ton",null,null,null,"Yield as bales",{"$f":"IF(AG13=1,StrawYield/DensityBigBale,(IF(AG13=2,StrawYield/Normer!M29,StrawYield/Normer!M31)))","v":2812.1599999999994},"m3",null,null,null,"Choose either extruding, briquetting or none",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
["Cultivated area",null,200,"ha.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Distance to briquetter, km",null,17,"km",null,null,null,null,null,null,null,null,null,1]
["Yield per hectare",null,3.38,"ton/ha.",null,null,null,null,null,null,null,null,null,"Capacity",{"$f":"IF($AG$18=TRUE,Ex_kap,\"\")","v":""},null,"ton/yr"]
["Dry matter",null,0.89,null,null,null,null,"Prices for main buildings can be changed in tabels",null,null,null,null,null,"Used capacity for straw",{"$f":"IF($AG$18=TRUE,StrawYield/O6,\"\")","v":""},{"$f":"IF(AG18=TRUE,I27/Ex_kap*100,\"\")","v":""},null,null,null,"Loading/unloading - briquettes",null,null,null,null,null,null,null,null,null,null,null,null,2,null,1]
["Organic matter - VS/total",null,{"$f":"0.86","v":0.86},null,null,null,null,"Open barn",{"$f":"-Tabels!C33","v":-1001500},"kr/5000m3",null,null,null,"Total used capacity",0.8,48,null,null,null,"Telescopic loader",null,{"$f":"BrLoadCost","v":-700},"kr./hr",null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,"Barn, concrete floor",{"$f":"-Tabels!C34","v":-1816500},"kr/5000m3",null,null,null,"Yearly costs",{"$f":"Ex_payment","v":-822940.78682646144},null,"kr/yr",null,null,"Loading speed",null,{"$f":"Normer!I23","v":0.6},"min/ton",null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,"Barn, gravel floor",{"$f":"-Tabels!C35","v":-1391500},"kr/5000m3",null,null,null,"Cost covered by straw",{"$f":"IF($AG$18=TRUE,(O9/O8)*O7,\"\")","v":""},null,"kr/yr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,true]
["Field expenses",null,null,null,null,null,null,"POMI Tube wrap",-30,"kr/bale",null,null,null,"Cost covered by straw",{"$f":"IF($AG$18=TRUE,O10/I27,0)","v":0},null,"kr/ton",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,"Rick/stack (labour not incl.)",{"$f":"Tabels!D45","v":-11.4},"kr/bale",null,null,null,null,null,null,null,null,null,"Decentral pretreatment",null,null,null,null,null,null,null,null,null,null,null,null,1]
["Tedding & Raking",null,{"$f":"IF(AK10,-160*CultivatedArea/StrawYield,0)","v":-47.337278106508876},"kr./ton",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity",null,{"$f":"BrKap","v":5800},"ton/yr",null,null,null,null,null,null,null,null,null,3]
["Bale type",null,{"$f":"VLOOKUP(AG13,Tabels!K15:N17,4)/1000","v":0.9},"ton",null,null,null,"Skal have indbygget det sidste nye med haybuster og ensilering af våd halm",null,null,null,null,null,"Capacity",{"$f":"IF($AG$19=TRUE,BrKap,\"\")","v":""},null,"ton/yr",null,null,"%-usage for straw from this farm",null,{"$f":"StrawYield/PresserKap*100","v":11.655172413793103},"%"]
["Baling",null,{"$f":"-78*Strawbaleweight","v":-70.2},"kr./ton",null,null,null,"Storage at farm",null,null,null,null,null,"Used capacity for straw",{"$f":"IF($AG$19=TRUE,StrawYield/O14,\"\")","v":""},{"$f":"IF(AG26=TRUE,I35/Ex_kap*100,\"\")","v":""},null,null,null,"%-usage in total",null,80,"%",null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total used capacity",0.8,48,null,null,null,"Yearly costs",null,{"$f":"Br_Payment","v":-785398.36415418983},"kr./yr",null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Yearly costs",{"$f":"Br_Payment","v":-785398.36415418983},null,"kr/yr",null,null,"Cost covered by straw",null,{"$f":"(V16/V15)*V14","v":-114424.41684660179},"kr./yr",null,null,null,null,null,null,null,null,null,3]
["Transport to farmer/barn",null,null,null,null,null,null,{"$f":"VLOOKUP(AG8,Storage,2)","v":"No storage"},{"$f":"IF(AG13=1,VLOOKUP(AG8,Storage,4),(IF(AG13=2,VLOOKUP(AG8,Storage,5),VLOOKUP(AG8,Storage,7))))","v":0},"kr/ton",null,null,null,"Cost covered by straw",{"$f":"IF($AG$19=TRUE,(O17/O16)*O15,\"\")","v":""},null,"kr/yr",null,null,"Cost covered by straw",null,{"$f":"V17/StrawYield","v":-169.266888826334},"kr./ton",null,null,null,null,null,null,null,null,null,false]
["Distance",null,2,"km",null,null,null,null,null,null,null,null,null,"Cost covered by straw",{"$f":"IF($AG$19=TRUE,O18/I27,0)","v":0},null,"kr/ton",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
["Tractor equipped with front loader & 2 bale trailers",null,{"$f":"Normer!TractorFrontWagon","v":-675},"kr./hr",null,null,null,{"$f":"IF(AI7=2,\"Note: Briquettes can be stored in barn for bales\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Transport videre til anlæg"]
["Bale capacity",null,{"$f":"Normer!F_kapacitet_baller_1mand","v":24},"bales/load",null,null,null,null,null,null,null,null,null,"Storage of bales at facility",null,null,null,null,null,"Distance, km",null,10,"km"]
["Capacity in tonnes",null,{"$f":"BaleCapacity*Strawbaleweight","v":21.6},"ton/load",null,null,null,"Storage period at farm",null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AG7,Tabels!K8:N10,2)","v":"Large dump truck"},null,{"$f":"VLOOKUP(AG7,Tabels!$K$8:$N$10,3)","v":-650},"kr./hr"]
["Loading rate, field",null,{"$f":"Loading_field/Yieldperha","v":2.6627218934911245},"min/ton",null,null,null,"Storage loss calculation",null,null,null,null,null,null,null,null,null,null,null,"Capacitet, m3/load",null,{"$f":"VLOOKUP(AG7,Tabels!$K$8:$N$10,4)","v":48},"m3/load"]
[null,null,null,null,null,null,null,"Months until delievery",5,null,null,null,null,{"$f":"VLOOKUP(AG16,Storage,2)","v":"No storage"},{"$f":"IF(AG8=1,VLOOKUP(AG16,Storage,4),VLOOKUP(AG16,Storage,5))","v":0},"kr/ton",null,null,null,"Capacitet, ton/load",null,{"$f":"V23*DensBr","v":21.6},"ton/load"]
["Farm Loading",null,null,null,null,null,null,"Storage loss per month",5.0000000000000001E-3,null,null,null,null,"Months until delievery",3]
[null,null,null,null,null,null,null,"Storage loss",{"$f":"IF(AG8=6,\"No storage\",StrawYield*(1-POWER((1-I25),I24)))","v":"No storage"},{"$f":"IF(AG8=6,\"\",\"ton\")","v":""},null,null,null,"Storage loss per month",5.0000000000000001E-3]
[{"$f":"VLOOKUP(AG7,Tabels!K4:N5,2)","v":"Telescopic loader"},null,{"$f":"VLOOKUP(AG7,Tabels!K4:M5,3)","v":-700},"kr./hr",null,null,null,"Remaining yield",{"$f":"IF(AG8=6,StrawYield,StrawYield*POWER(1-I25,I24))","v":676},"ton",null,null,null,"Storage loss",{"$f":"IF(AG16=6,\"No storage\",I27*(1-POWER((1-O26),O25)))","v":"No storage"},"ton",{"$f":"IF(AG16=6,\"\",\"ton\")","v":""}]
[{"$f":"VLOOKUP(AG7,Tabels!K4:P5,5)","v":"Loading speed"},null,{"$f":"VLOOKUP(AG7,Tabels!K4:P6,6)","v":0.82},"min/ton",null,null,null,null,null,null,null,null,null,"Remaining yield",{"$f":"IF(AG16=6,I27,I27*POWER(1-O26,O25))","v":676},"ton","ton",null,null,"Storage of bales at decentral"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Storage of briquettes at facility"]
["Transport of bales to facility or decentral storage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AG10,Storage,2)","v":"Barn, gravel floor"},{"$f":"IF(AG8=1,VLOOKUP(AG10,Storage,4),VLOOKUP(AG10,Storage,5))","v":-209.92124697949927},"kr/ton"]
[null,null,null,null,null,null,null,"Haybuster og ensilering af halm",null,null,null,null,null,null,null,null,null,null,null,"Months until delievery",3]
["Distance from farm to facility",null,5,"km",null,null,null,null,{"$f":"136*Normer!X5+(1400/100)","v":95.6},"kr/ton",null,null,null,{"$f":"VLOOKUP(AG17,Tabels!$H$42:$J$44,2)","v":"No storage"},{"$f":"VLOOKUP(AG17,Tabels!$H$42:$J$44,3)","v":0},"kr/ton",null,null,null,"Storage loss per month",5.0000000000000001E-3]
[{"$f":"VLOOKUP(AG3,Tabels!K12:M13,2)","v":"Truck & 2 trailers"},null,{"$f":"VLOOKUP(AG3,Tabels!K12:M13,3)","v":-675},"kr./time",null,null,null,"Haybuster drives ved hjælp af traktor. Der bruges 136 kWh/ton tør halm",null,null,null,null,null,"Months until delievery",1,null,null,null,null,"Storage loss",{"$f":"IF(AG10=6,\"No storage\",StrawYield*(1-POWER((1-U33),U32)))","v":10.089384499999989},{"$f":"IF(AG10=6,\"\",\"ton\")","v":"ton"}]
["Bale capacity",null,{"$f":"VLOOKUP(AG13,Tabels!K15:O17,5)","v":24},"bales/load",null,null,null,"Hvis den blev drevet af elmotor ville energiforbruget være 1/3 (45 kwh/t)",null,null,null,null,null,"Storage loss per month",1E-3,null,null,null,null,"Remaining yield after storage",{"$f":"IF(AG10=3,StrawYield,StrawYield*POWER(1-U33,U32))","v":676},"ton"]
["Capacity in tonnes",null,{"$f":"VLOOKUP(AG13,Tabels!K15:O17,4)*TransBaleCap/1000","v":21.6},"ton/load",null,null,null,"Kilde: Møller i taskforce rapport fra 2016",null,null,null,null,null,"Storage loss",{"$f":"IF(AG17=3,\"No storage\",O28*(1-POWER((1-O35),O34)))","v":"No storage"},"ton",{"$f":"IF(AG17=6,\"\",\"ton\")","v":"ton"}]
["Driving speed, main road",null,{"$f":"VLOOKUP(AG3,Tabels!K12:P13,6)","v":51.5},"km/hr",null,null,null,"                                                                          ",null,null,null,null,null,"Remaining yield after storage",{"$f":"IF(AG17=3,O28,O28*POWER(1-O35,O34))","v":676},"tonnes","ton",null,null,"Storage of briquettes at decentral"]
[null,null,null,null,null,null,null,"Rådden halm derimod ligger omkring 250 /90 dage"]
[]
["Facility loading",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AG11,Tabels!$H$42:$J$44,2)","v":"No storage"},{"$f":"VLOOKUP(AG11,Tabels!$H$42:$J$44,3)","v":0},"kr/ton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Months until delievery",3]
[{"$f":"VLOOKUP(AG2,Tabels!K4:M7,2)","v":"Telescopic loader"},null,{"$f":"VLOOKUP(AG2,Tabels!K4:M7,3)","v":-700},"kr./hr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Storage loss per month",1E-3]
[{"$f":"VLOOKUP(AG2,Tabels!K4:P5,5)","v":"Loading speed"},null,{"$f":"VLOOKUP(AG2,Tabels!K4:P7,6)","v":0.82},"min/ton",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Storage loss",{"$f":"IF(AG11=3,\"No storage\",U35*(1-POWER((1-U42),U41)))","v":"No storage"},{"$f":"IF(AG11=3,\"\",\"ton\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remaining yield after storage",{"$f":"IF(AG11=3,U35,U35*POWER(1-U42,U41))","v":676},"ton"]
[null,null,null,null,{"$f":"IF(AG2=4,\"Loading costs is covered by plant construction costs\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Storage of briquettes at facility"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AG12,Tabels!$H$42:$J$44,2)","v":"Barn, concrete floor"},{"$f":"VLOOKUP(AG12,Tabels!$H$42:$J$44,3)","v":-117.47111268416008},"kr/ton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Months until delievery",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Storage loss per month",1E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Storage loss",{"$f":"IF(AG12=3,\"No storage\",U44*(1-POWER((1-U51),U50)))","v":2.0259726759999994},{"$f":"IF(AG12=3,\"\",\"ton\")","v":"ton"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Remaining yield after storage",{"$f":"IF(AG12=3,U44,U44*POWER(1-U51,U50))","v":673.97402732399996},"ton"]

{"sheet":"Rape straw","index":2,"n_rows":43,"n_cols":44,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,12,0,16],[7,7,7,8],[7,9,7,10],[5,13,5,14],[13,13,13,14]]}
["Entry for rape straw",null,null,null,null,null,null,null,null,null,null,null,"Facility",null,null,null,null,null,null,null,null,null,null,null,null,null,1,false,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"Straw!A3","v":"Yield"},null,null,null,null,null,{"$f":"Straw!H3","v":"Storage"},null,null,null,null,null,"Pretreatment",null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"Straw!A4","v":"Yield"},null,{"$f":"C5*C6","v":650},"ton",null,null,{"$f":"A4","v":"Yield"},{"$f":"RapeYield","v":650},"ton",null,null,null,"Choose either extruding, briquetting or none",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[{"$f":"Straw!A5","v":"Cultivated area"},null,200,"ha.",null,null,{"$f":"Straw!H4","v":"Yield as bales"},{"$f":"H4/C18","v":4062.5},"m3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,1]
[{"$f":"Straw!A6","v":"Yield per hectare"},null,3.25,"ton/ha.",null,null,"Yield as briquettes",{"$f":"H4/DensBr","v":1444.4444444444443},"m3",null,null,null,"Capacity",{"$f":"IF(AB1=TRUE,Ex_kap,\"\")","v":""},null,"ton/yr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"Straw!A7","v":"Dry matter"},null,0.89,null,null,null,null,null,null,null,null,null,"Used capacity for straw",{"$f":"IF($AG$18=TRUE,StrawYield/N6,\"\")","v":""},{"$f":"IF(AB1=TRUE,H4/N6,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[{"$f":"Straw!A8","v":"Organic matter - VS/total"},null,0.81599999999999995,null,null,null,{"$f":"Straw!H7","v":"Prices for main buildings can be changed in tabels"},"Cost",null,null,null,null,"Total used capacity",{"$f":"IF($AG$18=TRUE,StrawYield/N7,\"\")","v":""},0.8,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Methane potential",null,{"$f":"MethaneRape","v":310},"L CH4/kg VS",null,null,{"$f":"Straw!H8","v":"Open barn"},{"$f":"Straw!I8","v":-1001500},{"$f":"Straw!J8","v":"kr/5000m3"},null,null,null,"Yearly costs",{"$f":"IF($AG$18=TRUE,StrawYield/N8,\"\")","v":""},{"$f":"Ex_payment","v":-822940.78682646144},"kr/yr",null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,{"$f":"Straw!H9","v":"Barn, concrete floor"},{"$f":"Straw!I9","v":-1816500},{"$f":"Straw!J9","v":"kr/5000m3"},null,null,null,"Cost covered by straw",{"$f":"IF($AG$18=TRUE,(N9/N8)*N7,\"\")","v":""},{"$f":"IF(AB1=TRUE,(O9/O8)*O7,\"\")","v":""},"kr/yr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,null,null,null,1]
[{"$f":"Straw!A11","v":"Field expenses"},null,null,null,null,null,{"$f":"Straw!H10","v":"Barn, gravel floor"},{"$f":"Straw!I10","v":-1391500},{"$f":"Straw!J10","v":"kr/5000m3"},null,null,null,"Cost covered by straw",null,{"$f":"IF(AB1=TRUE,O10/H26,0)","v":0},"kr/ton",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Tedding & Raking",null,{"$f":"IF(AK10,-160*C5/RapeYield,0)","v":-49.230769230769234},"kr./ton",null,null,{"$f":"Straw!H11","v":"POMI Tube wrap"},{"$f":"Straw!I11","v":-30},{"$f":"Straw!J11","v":"kr/bale"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"Straw!A15","v":"Baling"},null,{"$f":"-78*C17","v":-42.900000000000006},"kr./ton",null,null,{"$f":"Straw!H12","v":"Rick/stack (labour not incl.)"},{"$f":"Straw!I12","v":-11.4},{"$f":"Straw!J12","v":"kr/bale"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,"Capacity",{"$f":"IF(AB2=TRUE,BrKap,\"\")","v":""},null,"ton/yr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Bale type",null,null,null,null,null,null,null,null,null,null,null,"Used capacity for straw",null,{"$f":"IF(AB2=TRUE,RapeYield/BrKap,\"\")","v":""}]
[null,null,null,null,null,null,"Storage of bales at farm",null,null,null,null,null,"Total used capacity",null,0.8]
["Weight",null,{"$f":"IF(Z8=1,BigBaleWeight,Normer!M28)","v":0.55000000000000004},"ton",null,null,null,null,null,null,null,null,"Yearly costs",null,{"$f":"Br_Payment","v":-785398.36415418983},"kr/yr"]
["Density",null,{"$f":"IF(Z8=1,DensityBigBale,Normer!M29)","v":0.16},"ton/m3",null,null,null,null,null,null,null,null,"Cost covered by straw",null,{"$f":"IF(AB2=TRUE,(O17/O16)*O15,\"\")","v":""},"kr/yr"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(AA1,Storage,2)","v":"Open barn"},{"$f":"IF(Z8=1,VLOOKUP(AA1,Storage,4),VLOOKUP(AA1,Storage,5))","v":-193.8146462305991},"kr/ton",null,null,null,"Cost covered by straw",null,{"$f":"IF(AB2=TRUE,O18/H26,0)","v":0},"kr/ton",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[{"$f":"Straw!A18","v":"Transport to farmer/barn"}]
[{"$f":"Straw!A19","v":"Distance"},null,5,"km"]
[{"$f":"Straw!A20","v":"Tractor equipped with front loader & 2 bale trailers"},null,{"$f":"Normer!TractorFrontWagon","v":-675},"kr/hr",null,null,"Storage loss calculation",null,null,null,null,null,"Storage of bales at facility"]
[{"$f":"Straw!A21","v":"Bale capacity"},null,{"$f":"Normer!F_kapacitet_baller_1mand","v":24},"bales/load",null,null,"Months until delievery",6]
[{"$f":"Straw!A22","v":"Capacity in tonnes"},null,{"$f":"Normer!F_kapacitet_baller_1mand*C17","v":13.200000000000001},"ton",null,null,"Storage loss per month",0.08,5.0000000000000001E-3]
[{"$f":"Straw!A23","v":"Loading rate, field"},null,{"$f":"Loading_field/C6","v":2.7692307692307692},"min/ton",null,null,"Storage loss",{"$f":"IF(AA1=6,\"No storage\",RapeYield*(1-POWER((1-H24),H23)))","v":255.86924912639992},5.0000000000000001E-3,null,null,null,{"$f":"VLOOKUP(AA3,Storage,2)","v":"No storage"},null,{"$f":"IF(Z8=1,VLOOKUP(AA3,Storage,4),VLOOKUP(AA3,Storage,5))","v":0},"kr/ton"]
[null,null,null,null,{"$f":"3*2+1","v":7},null,"Remaining yield after storage",{"$f":"IF(AA1=6,RapeYield,RapeYield*POWER(1-H24,H23))","v":394.13075087360005},null,null,null,null,"Months until delievery",null,6]
[{"$f":"Straw!A25","v":"Farm Loading"},null,null,null,{"$f":"7*6+5","v":47},null,null,null,null,null,null,null,"Storage loss per month",null,0.05]
[null,null,null,null,{"$f":"10*9+8","v":98},null,null,null,null,null,null,null,"Storage loss",null,{"$f":"IF(AA3=6,\"No storage\",H26*(1-POWER((1-O27),O26)))","v":"No storage"},{"$f":"IF(AB3=6,\"\",\"ton\")","v":"ton"}]
[{"$f":"VLOOKUP(AR2,Tabels!K4:N5,2)","v":"Tractor & Frontloader"},null,{"$f":"VLOOKUP(AR2,Tabels!K4:M6,3)","v":-675},"kr./hr",{"$f":"9*8+7","v":79},null,null,null,null,null,null,null,"Remaining yield after storage",null,{"$f":"IF(AA3=6,H26,H26*POWER(1-O27,O26))","v":394.13075087360005},"ton"]
[{"$f":"VLOOKUP(AR2,Tabels!K4:P5,5)","v":"Loading speed"},null,{"$f":"VLOOKUP(AR2,Tabels!K4:P6,6)","v":0.61},"min/ton",{"$f":"10*9+8","v":98}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Storage of briquettes at facility"]
["Transport to facility"]
[]
["Distance",null,5,"km",null,null,null,null,null,null,null,null,{"$f":"IF(AR4=2,VLOOKUP(AA2,Tabels!H42:J44,2),\"No storage of briquettes\")","v":"No storage"},null,{"$f":"IF(AR4=2,VLOOKUP(AA2,Tabels!H42:J44,3),0)","v":0},"kr/ton"]
[{"$f":"VLOOKUP(AR3,Tabels!K12:M13,2)","v":"Truck & 2 trailers"},null,{"$f":"VLOOKUP(AR3,Tabels!K12:M13,3)","v":-675},"kr./hr",null,null,null,null,null,null,null,null,"Months until delievery",null,6]
["Capacity, bales",null,{"$f":"VLOOKUP(AR3,Tabels!K12:N13,4)","v":24},"bales/load",null,null,null,null,null,null,null,null,"Storage loss per month",null,0.05]
["Capacity, tonnes",null,{"$f":"C36*C17","v":13.200000000000001},"ton/load",null,null,null,null,null,null,null,null,"Storage loss",null,{"$f":"IF(AA2=3,\"No storage\",O29*(1-POWER((1-O36),O35)))","v":"No storage"},{"$f":"IF(AB2=3,\"\",\"ton\")","v":"ton"}]
["Driving speed",null,{"$f":"VLOOKUP(AR3,Tabels!K12:P13,6)","v":51.5},"km/hr",null,null,null,null,null,null,null,null,"Remaining yield after storage",null,{"$f":"IF(AA2=3,O29,O29*POWER(1-O36,O35))","v":394.13075087360005},"ton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"containers"]
[{"$f":"Straw!A40","v":"Facility loading"}]
[]
[{"$f":"VLOOKUP(AR5,Tabels!K4:N5,2)","v":"Tractor & Frontloader"},null,{"$f":"VLOOKUP(AR5,Tabels!K4:M6,3)","v":-675},"kr./time",null,null,null,null,null,null,null,null,{"$f":"IF(AR5=4,\"Loading costs is covered by plant construction costs\",\"\")","v":""}]
[{"$f":"VLOOKUP(AR5,Tabels!K4:P5,5)","v":"Loading speed"},null,{"$f":"VLOOKUP(AR5,Tabels!K4:P6,6)","v":0.61},"min/ton"]

{"sheet":"Meadow grass","index":3,"n_rows":39,"n_cols":33,"rows_kept":39,"cut":false,"hidden":false,"merged":[[10,11,10,12],[14,11,14,12],[5,11,5,12],[12,11,12,12]]}
["Entry for meadow grass/hay"]
[]
[{"$f":"Straw!A3","v":"Yield"},null,null,null,null,"Storage (only at facility)",null,null,null,null,"Pretreatment at facility",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"Straw!A4","v":"Yield"},null,{"$f":"C5*C6","v":66},"ton",null,"Yield as bales",{"$f":"MeaYield/Rundballevægt","v":235.71428571428569},"pcs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[{"$f":"Straw!A5","v":"Cultivated area"},null,12,"ha.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[{"$f":"Straw!A6","v":"Yield per hectare"},null,5.5,"ton/ha.",null,null,null,null,null,null,"Capacity",{"$f":"IF($AG$4=TRUE,Ex_kap,\"\")","v":""},null,"ton/yr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"Straw!A7","v":"Dry matter"},null,0.8,"%",0.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[{"$f":"Straw!A8","v":"Organic matter - VS/total"},null,{"$f":"0.85*C7","v":0.68},"%",null,null,null,null,null,null,"Used capacity for meadow grass",null,{"$f":"IF(AG4=TRUE,MeaYield/Ex_kap*100,\"\")","v":""},"%"]
["Weight bale",null,{"$f":"Normer!N32","v":0.28000000000000003},"ton/bale",null,{"$f":"IF(C7<E7,\"Storage without cover is only recommeded if TS>E7\",\"TS> E7: Open storage is an option\")","v":"TS> E7: Open storage is an option"},null,null,null,null,"Used for other purposes",null,48,"%"]
[null,null,null,null,null,"Storage costs",{"$f":"IF(AG7=1,Tabels!C11,IF(AG7=2,Tabels!C12,0))","v":0},"kr./ton"]
["Metane potential",null,null,null,null,null,null,null,null,null,"Extruder, mixer, conveyor",{"$f":"IF($AG$4=TRUE,Ex_TotalCost,\"\")","v":""},null,"kr."]
["Metane potential, fine cuttings",null,{"$f":"Normer!Y20","v":250},"L CH4/kg VS",null,null,"Ikke lagt i resultatark endnu.",null,null,null,"Operation & maintainance",null,{"$f":"IF($AG$4=TRUE,Ex_OandM,\"\")","v":""},"kr./ton"]
["Metane potential,  extruded",null,{"$f":"Normer!Y21","v":300},"L CH4/kg VS",null,"Storage loss calculation",null,null,null,null,"Insurance",{"$f":"IF($AG$4=TRUE,EX_ensurance,\"\")","v":""},null,"kr./yr"]
[null,null,null,null,null,"Months until used",6,"months",null,null,"Expected lifetime",null,{"$f":"IF($AG$4=TRUE,10,\"\")","v":""},"yr"]
[null,null,null,null,null,"Storage loss per month",0.05,"pct",null,null,"Yearly expenses",{"$f":"IF($AG$4=TRUE,Ex_payment,\"\")","v":""},null,"kr./yr"]
["Cutting, pressing & transport (tractor & wagon)",null,null,null,null,"Remaining yield after storage",{"$f":"MeaYield*POWER(1-G15,G14)","v":48.516064781249995},"ton"]
["Includes transport of approx. 12 km from field to farmer or facility",null,null,null,null,"Storage loss",{"$f":"MeaYield*(1-POWER((1-G15),G14))","v":17.483935218750005},"ton"]
["Type of meadow"]
[]
[null,null,null,null,null,"Normal range of storage loss, DM range 80-90"]
["Windrowing and bailing device on a",null,null,null,null,null,"Yearly"]
[{"$f":"IF(AG3=1,Tabels!C7,Tabels!C8)","v":"Tractor"},null,{"$f":"IF(AG3=1,Tabels!D7,Tabels!D8)","v":-2067},"kr./ha",null,"POMI tube wrap ","5-10%"]
[null,null,null,null,null,"Bales under cover","5-15%",null,null,null,null,null,null,null,null,null,null,{"$f":"PMT(0.05,10,1000000)","v":-129504.57496545668}]
[null,null,null,null,null,"Open storage","10-30%"]
["Transport exceeding 12 km (loading/unloading incl.)"]
["Means of transport"]
["   "]
[null,null,null,null,null,null,{"$f":"'Results  meadow grass'!E16","v":-66.129229486988095}]
["Road distance",null,15,"km",null,null,{"$f":"'Results  meadow grass'!E12","v":-63.906667079854564}]
[{"$f":"VLOOKUP(AG5,Tabels!A17:E18,3)","v":"Tractor & trailer"},null,{"$f":"VLOOKUP(AG5,Tabels!A17:E18,4)","v":-675},"kr./hr"]
["Capacity, bales",null,{"$f":"IF(AG5=1,Normer!D19,Normer!D8)","v":27},"Bales/load"]
["Capacity, tonnes",null,{"$f":"VLOOKUP(AG5,Tabels!A17:E18,5)","v":7.5600000000000005},"ton"]
["Driving speed",null,{"$f":"VLOOKUP(AG5,Tabels!A17:F18,6)","v":25},"km/hr"]
[]
["Loading equipment"]
[]
[]
[{"$f":"IF(AG6=1,\"Tractor & frontloader\",(IF(AG6=2,\"Telescopic loader\",\"No reload\")))","v":"Tractor & frontloader"},null,{"$f":"IF(AG6=1,Normer!I6,(IF(AG6=2,BrLoadCost,0)))","v":-650},"kr./time"]
["Loading speed",null,{"$f":"IF(AG6=1,Normer!H10,(IF(AG6=2,BrLoadRoundCap,0)))","v":2.1264367816091956},"min/ton"]

{"sheet":"Beets","index":4,"n_rows":66,"n_cols":32,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Entry for beets"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Info on biomass",null,null,null,null,"Transport",null,null,null,null,"Storage at facility",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Soil type:",null,null,null,null,null,null,"Check lige beregning i gen",null,null,null,null,null,null,null,"Stak er ikke en god idé. For stor risiko for at miste saft. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,"Transport from beet lifter to pile of beets",null,null,null,null,"Stored as",null,null,null,null,"Lagring af hele roer i plansilo. Bemærk at roer ikke kan mases. De falder sammen under ensileringsprocessen og densiteten ændres. Færdig ensileret på ca. 10 dage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Cultivated area",null,50,"ha",null,"Distance to pile",null,1.5,"km",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Yield",null,86,"ton/ha",null,"Tractor & Dumper",null,{"$f":"Normer!C24","v":-625},"kr./hr.",null,"Whole beets:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["Yield in tonnes",null,{"$f":"C6*C7","v":4300},"ton",{"$f":"BeetYield*BeetTS/C6","v":19.178000000000001},"Capacity",null,{"$f":"Normer!C25","v":35},"m3/load",null,"Storage needed",null,{"$f":"IF(BeetStorage=2,\"\",BeetYield/BeetDensity)","v":6142.8571428571431},"m3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["Dry matter, %",null,0.223,null,null,"Capacity, ton",null,{"$f":"H8*Normer!M40","v":24.5},"ton/load",null,"Clamp silo 3x50x16 meter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["VS , %",null,{"$f":"0.9*C9","v":0.20070000000000002},null,null,"Driving Speed",null,{"$f":"TractorSpeedField","v":15},"km/hr.",null,"Clamp Silo volume",null,{"$f":"IF(BeetStorage=2,\"\",Tabels!E56)","v":3527.9999999999995},"m3"]
["Methane potential",null,{"$f":"Normer!X27","v":380},"L CH4/kg VS",null,null,null,null,null,null,"Clamps needed",null,{"$f":"IF(BeetStorage=1,M8/M10,\"\")","v":1.7411726595400068},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AF6,'Raw data Beets'!B37:C40,2)","v":2000}]
[null,null,null,null,null,"Loading from pile",null,null,null,null,"Clamps builded",null,{"$f":"IF(BeetStorage=1,CEILING(M11,1),\"\")","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(AF7,'Raw data Beets'!B37:C40,2)","v":3000}]
["Cultivation costs",null,null,null,null,null,null,null,null,null,"Cost",null,{"$f":"IF(BeetStorage=2,\"\",Tabels!G76)","v":-11.377034333847106},"kr./ton"]
["Maize seeds",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,3)","v":-1300},"kr./ha"]
["Removal of weeds",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,8)","v":-2245},"kr./ha",null,{"$f":"VLOOKUP(AF4,'Raw data Beets'!A43:D44,2)","v":"Beetloader with dry clean shovel"},null,{"$f":"VLOOKUP(AF4,'Raw data Beets'!A43:D44,3)","v":-12},{"$f":"IF(AF4=1,\"kr./hr.\",\"kr./ton\")","v":"kr./ton"}]
["Fertilizer, N",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,4)","v":-1197},"kr./ha",null,{"$f":"IF(AF4=1,\"Load capacity\",\"\")","v":""},null,{"$f":"IF(AF4=1,'Raw data Beets'!D43,\"\")","v":""},{"$f":"IF(AF4=1,\"min/ton\",\"\")","v":""},null,"Roepulp:"]
["Fertilizer, P",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,5)","v":-276},"kr./ha",null,null,null,null,null,null,"Storage need",null,{"$f":"IF(BeetStorage=1,\"\",BeetYield/BeetpulpDensity)","v":""},"m3"]
["Fertilizer, K",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,6)","v":-1065},"kr./ha",null,"Transport from pile to facility"]
["Manure",null,"No cost",null,null,"Distance to facility",null,0,"km",null,"Number of silos",null,2,"pcs","size",{"$f":"(M19*(VLOOKUP(AF6,'Raw data Beets'!B37:C40,2)))","v":4000}]
[null,null,null,null,null,"Large Dumper",null,{"$f":"L_Dumper","v":-675},"kr./hr.",null,"AND"]
[null,null,null,null,null,"Capacity",null,{"$f":"LorryDumpCap","v":55},"m3/load",null,"Number of silos",null,0,"pcs","size",{"$f":"(M21*(VLOOKUP(AF7,'Raw data Beets'!B37:C40,2)))","v":0}]
["Machinery costs",null,null,null,null,"Capacity in tonnes",null,{"$f":"H21*Roedensitet","v":38.5},"ton/load"]
["Ploughing",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,9)","v":-608},"kr./ha",null,"Driving speed",null,{"$f":"LorrySpeed","v":51.5},"km/hr.",null,"Storage in total",null,{"$f":"(M19*(VLOOKUP(AF6,'Raw data Beets'!B37:C40,2)))+(M21*(VLOOKUP(AF7,'Raw data Beets'!B37:C40,2)))","v":4000},"m3"]
["Harrowing",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,10)","v":-304},"kr./ha",null,null,null,null,null,null,null,null,{"$f":"IF(BeetStorage=2,(IF(M23>M17,\"\",\"More storage needed\")),\"\")","v":""}]
["Manure spreding",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,11)","v":0},"kr./ha",null,null,null,null,null,null,"Cost",null,{"$f":"(((M19*(VLOOKUP(AF6,'Raw data Beets'!A37:M40,13)))*P19)+((M21*(VLOOKUP(AF7,'Raw data Beets'!A37:M40,13)))*P21))/M23","v":-39.503338122891265},"kr/m3 tank"]
["Fertilizer spreading",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,12)","v":-133},"kr./ha",null,"Cleaning of beets, facility site, before storage",null,null,null,null,"Cost per ton beet",null,{"$f":"(M25*M23)/BeetYield","v":-36.747291277108154},"kr/ton"]
["Seeding",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,13)","v":-523},"kr./ha"]
["Rolling",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,14)","v":-165},"kr./ha"]
["Spreading pesticide",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,15)","v":-1290},"kr./ha",null,{"$f":"VLOOKUP(BeetClean,'Raw data Beets'!A28:F30,2)","v":"Elephant beet washer"},null,{"$f":"VLOOKUP(BeetClean,'Raw data Beets'!A28:F30,3)","v":-1120},"kr./hr.",null,"Storage loss silage/pulp"]
["Beet lifting",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,16)","v":-1613},"kr./ha",null,"Capacity",null,{"$f":"VLOOKUP(BeetClean,'Raw data Beets'!A28:F30,4)","v":70},"ton/hr.",null,"Storage loss during ensilation",null,null,null,null,"Storage loss, beets: Losses in organic matter (and weight losses) during storage are higher than energy losses if the beets are used for biogas production. The alcohol content of the silage has a significant higher energy value than the sugars it was produced from. "]
["Irrigation, fix cost",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,17)","v":0},"kr./ha",null,"Water usage",null,{"$f":"VLOOKUP(BeetClean,'Raw data Beets'!A28:F30,5)","v":50},"L/ton",null,"Estimated loss during storage",null,null,null,null,"Storage loss, normal values"]
["Irrigation, moving of",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,18)","v":0},"kr.",null,"Water costs",null,{"$f":"VLOOKUP(BeetClean,'Raw data Beets'!A28:F30,6)","v":-0.3},"kr./ton",null,"Loss during first month",null,0.03,null,null,"Pulp"]
["Irrigation water, pr mm, average year",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,19)","v":0},"kr.",null,{"$f":"IF(BeetClean=2,\"Transport, fast pris\",\"\")","v":""},null,{"$f":"IF(BeetClean=2,-750,\"\")","v":""},"kr",null,"Months until delievery",null,6,null,null,"Whole beets"]
["Other tasks related to beets",null,{"$f":"VLOOKUP(BeetSoilType,Roetal,20)","v":-500},"kr.",null,"Total cost, KWS",null,{"$f":"IF(BeetClean=2,((BeetYield/H30*H29)+H33)/BeetYield+H32,\"\")","v":""},"kr./ton",null,"Storage loss per following month",null,5.0000000000000001E-3]
[null,null,null,null,null,{"$f":"IF(BeetClean=1,\"Transport trailer for elephant\",\"\")","v":"Transport trailer for elephant"},null,{"$f":"Normer!C28","v":-500},"kr./hr.",null,"Remaining yield after storage",null,{"$f":"(BeetYield*(1-M32))*POWER(1-M34,(M33-1))","v":4067.762549271341},"ton"]
[null,null,null,null,null,{"$f":"IF(BeetClean=1,\"Transport distance\",\"Only for Elephant\")","v":"Transport distance"},null,50,"km",null,"Storage loss",null,{"$f":"MaWetWeight-(MaWetWeight*(1-M32)*POWER((1-M34),(måned-1)))","v":63.773484144279109},"ton"]
[null,null,null,null,null,{"$f":"IF(BeetClean=1,\"Total transport cost, elephant\",\"\")","v":"Total transport cost, elephant"},null,{"$f":"IF(BeetClean=1,(H36/Normer!C40)*H35,\"\")","v":-555.55555555555554},"kr."]
[null,null,null,null,null,{"$f":"IF(BeetClean=1,\"Total cost, elephant\",\"\")","v":"Total cost, elephant"},null,{"$f":"IF(BeetClean=1,(((BeetYield/H30)*H29)/BeetYield)+H32+(H37/BeetYield),\"\")","v":-16.429198966408268},"kr./ton"]
[null,null,null,null,null,"Elephant may also fine cut beets"]
[]
[null,null,null,null,null,"Preparation of pulp/cutting of beets"]
[]
[null,null,null,null,null,"Haybuster",null,-1400,"kr./hr."]
[null,null,null,null,null,"(+transport of haybuster if less than 6h work)",null,400,"kr./hr."]
[null,null,null,null,null,"Capacity (80-100 t/hr.)",null,90,"ton/hr."]
[null,null,null,null,null,"Cost per ton",null,{"$f":"H43/H45","v":-15.555555555555555},"kr./ton"]
[]
[null,null,null,null,null,"Betacut",null,{"$f":"Normer!S48","v":-19955.071712577341},"kr/yr"]
[null,null,null,null,null,"Running costs",null,{"$f":"Normer!S49","v":0.216},"kr/ton"]
[null,null,null,null,null,"For this amount of beets",null,{"$f":"(H48/BeetYield)+H49","v":-4.4247143517621721},"kr/ton"]
[]
[]
[null,null,null,null,null,"snitning af roer med skovl"]
[null,null,null,null,null,"Roeskovl easybeets. 2.25 m3 roer eller godt et ton roer. "]
[null,null,null,null,null,"En rotor i bunden af skovlen renser jord fra. En snegl fører roerne til skæreren"]
[null,null,null,null,null,"Det tager godt tre minutter"]
[]
[null,null,null,null,null,"Snitning af roer med haybuster"]
[null,null,null,null,null,"På Grøngas snittes roer med haybuster og føres med bånd over i lagertanken"]
[null,null,null,null,null,"Diget maskinstation/Klitgård Agro vasker roerne med elefant og snitter dem i haybuster lige over i tanken"]
[null,null,null,null,null,"Haybusteren koster 1400 kr/timen og tager 80-100 ton i timen. Der tillægges 400 kr/timen til kørslen, hvis det er mindre et en halv dags arbejde."]
[null,null,null,null,null,"Haybuster",{"$f":"1400/90","v":15.555555555555555},"kr/ton"]
[]
[null,null,null,null,null,"Roer kan knuses med hydrauliske skovle, vertikal mixer og roeknusere (Elefant, Betacut, Ørum)"]
[null,null,null,null,null,"Ørum Roe Snitteskovl RS-16 rummer 5 ton roer, 90 ton/time, holder sten tilbage, monteres på Volvo 90 eller ligningende stor læsser"]
[null,null,null,null,null,"Betacut roeknuser (snitter). Stationær. 180 ton/time",null,null,"(spurgt Leif om priser)"]

{"sheet":"Maize","index":5,"n_rows":57,"n_cols":31,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Entry for Maize",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Measured",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,"Default"]
[{"$f":"Beets!A3","v":"Info on biomass"},null,null,null,null,"Transport further to facility including loading",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,"Default"]
["Jordtype:",null,null,null,null,"Means of transport",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Majsen sprøjtes direkte over i vogn bag traktor ",1]
[{"$f":"Beets!A6","v":"Cultivated area"},null,32,"ha",null,"Road distance",null,15,"km",null,null,null,null,null,null,null,null,null,null,null,"kontroller alle Yield om det er tørstof eller vådvægt"]
[{"$f":"Beets!A7","v":"Yield"},null,36.9,"ton/ha",null,"Vehicle costs",null,{"$f":"VLOOKUP($V$3,'Raw data Maize'!$A$30:$E$31,3)","v":-675},"kr./time"]
[{"$f":"Beets!A8","v":"Yield in tonnes"},null,{"$f":"C6*C7","v":1180.8},"ton",null,"Driving speed",null,{"$f":"VLOOKUP($V$3,'Raw data Maize'!$A$30:$E$31,5)","v":51.5},"km/t"]
[{"$f":"Beets!A9","v":"Dry matter, %"},null,0.34,null,null,"Capacity",null,{"$f":"VLOOKUP($V$3,'Raw data Maize'!$A$30:$E$31,4)","v":55},"m3/load",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dmrange",null,{"$f":"IF(C9<=30%,30%,(IF(C9<=35%,35%,IF(C9<=40%,40%,IF(C9<=50%,50%,\"FEJL!\")))))","v":0.35}]
[{"$f":"Beets!A10","v":"VS , %"},null,{"$f":"0.95*C9","v":0.32300000000000001},null,null,"Volumen, shredded maize",null,{"$f":"C8/Normer!M43","v":3690},"m3"]
[{"$f":"Beets!A11","v":"Methane potential"},null,{"$f":"[1]Forudsætninger!V31","v":286},"L CH4/kg VS"]
[]
[{"$f":"Beets!A13","v":"Cultivation costs"}]
[{"$f":"Beets!A14","v":"Maize seeds"},null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,3)","v":-1600},"kr./ha",null,"Storage cost silage"]
[{"$f":"Beets!A15","v":"Removal of weeds"},null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,8)","v":-440},"kr./ha",null,"Storage type"]
[{"$f":"Beets!A16","v":"Fertilizer, N"},null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,4)","v":-1077.3},"kr./ha",null,"Estimated total volume, ensiled maize",null,{"$f":"MaWetWeight/H50","v":6819.1268191268182},"m3"]
[{"$f":"Beets!A17","v":"Fertilizer, P"},null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,5)","v":-432},"kr./ha",null,{"$f":"IF(V5=1,\"Volume clamp silo\",\"Volume pile\")","v":"Volume clamp silo"},null,{"$f":"H33","v":2361.6524151731678},"m3"]
[{"$f":"Beets!A18","v":"Fertilizer, K"},null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,6)","v":-755},"kr./ha",null,"Silos/piles needed",null,{"$f":"H16/H17","v":2.8874388014574985}]
[{"$f":"Beets!A19","v":"Manure"},null,null,"kr./kg",null,"Silo,  yearly cost/m3",null,{"$f":"VLOOKUP(V5,'Raw data Maize'!A34:E35,4)","v":-33.677396917496971},"kr./m3 silo",null,null,null,null,null,null,null,null,null,null,null,"34 kr/m3 er lavt. Jeg har set 230-540 kr/m3 plansilo. Mon dette er per m3 majs?"]
[null,null,null,null,null,"Cost/ton",null,{"$f":"(H16*H19)/MaWetWeight","v":-194.4871616857067},"kr./ton",null,null,null,null,null,null,null,null,null,null,null,"Majs"]
[null,null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,21)","v":-1700}]
[{"$f":"Beets!A22","v":"Machinery costs"},null,null,null,null,"Density ensiled maize measured in one pile"]
[{"$f":"Beets!A23","v":"Ploughing"},null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,10)","v":-608},"kr./ha",null,"Lenght of pile/clamp",null,45,"m"]
["Spreading manure",null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,11)","v":0},"kr./ha",null,"Bottom width",null,15.8,"m"]
["Spreading fertilizer",null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,12)","v":-133},"kr./ha",null,"Top width under dome",null,15,"m"]
[{"$f":"'Raw data Maize'!M3","v":"Seed bed harrowing"},null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,13)","v":-152},"kr./ha",null,"Height under dome",null,3.2,"m",{"$f":"(H25^2/(8*H27))+(H27/2)","v":88.050624999999997}]
["Sowing",null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,14)","v":-475},"kr./ha",null,"Dome height",null,0.32,"m",{"$f":"J26-H27","v":87.730625000000003}]
[{"$f":"'Raw data Maize'!O3","v":"Rolling"},null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,15)","v":-165},"kr./ha",null,"Area of silage",null,{"$f":"(((H24+H25)/2)*H26)+((J26^2*ACOS(J27/J26))-J27*0.5*H25)","v":52.481164781625949},"m2",{"$f":"((J26^2*ACOS(J27/J26))-J27*0.5*H25)","v":3.2011647816259483}]
[{"$f":"'Raw data Maize'!P3","v":"Spread pesticide"},null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,16)","v":-350},"kr./ha",null,"Lenght of slide ",null,0.8,"m"]
["Fine cut., farm transport, deployment",null,-1500,"kr./ha",null,"Weight of slide",null,8,"ton"]
[{"$f":"'Raw data Maize'!Q3","v":"Irrigation"},null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,17)","v":0},"kr.",null,"Measured Silage Density in this pile",null,{"$f":"H30/(H28*H29)","v":0.19054455139496207},"ton/m3"]
[{"$f":"'Raw data Maize'!R3","v":"Irrigation, moving of"},null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,18)","v":0},"kr.",null,"Calculated Silage density in this pile",null,{"$f":"((316-(4.7*DMMaize*100)+(5.3*H26)))/1000","v":0.17316000000000001},"ton/m3"]
[{"$f":"'Raw data Maize'!S3","v":"Irrigation pr. ml"},null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,19)","v":0},"kr.",null,"Total volume in this pile",null,{"$f":"H28*H23","v":2361.6524151731678},"m3"]
[{"$f":"'Raw data Maize'!T3","v":"Other tasks"},null,{"$f":"VLOOKUP(MaizeAreatype,MaizeRaw,20)","v":-500},"kr.",null,"Weight of ensilage in this silo",null,null,"ton"]
[]
[null,null,null,null,null,"Storage loss"]
[null,null,null,null,null,"Estimated loss during storage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Losses influenced by ambient temperature especially during feed out",null,null,null,null,null,null,null,"v4","15cm","23cm"]
[null,null,null,null,null,"Loss during first month",null,0.03,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,0.192,0.16]
[null,null,null,null,null,"Months until delievery",null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,0.224,0.17599999999999999]
[null,null,null,null,null,"Storage loss per following month",null,5.0000000000000001E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.25600000000000001,0.20799999999999999]
[null,null,null,null,null,"Remaining yield after storage",null,{"$f":"(MaWetWeight*(1-H38))*POWER(1-H40,(måned-1))","v":1117.0265158557208},"ton",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,0.33600000000000002,0.27200000000000002]
[null,null,null,null,null,"Storage loss",null,{"$f":"MaWetWeight-(MaWetWeight*(1-H38)*POWER((1-H40),(måned-1)))","v":63.773484144279109},"ton"]
[]
[null,null,null,null,null,"Loss during feedout"]
[null,null,null,null,null,"Silage Density"]
[null,null,null,null,null,"Removal rate, choose the nearest"]
[]
[null,null,null,null,null,"Used dry matter in calculation of loss",null,{"$f":"IF(DMMaize<=25%,\"Too lowDM\",IF(DMMaize<=30%,30%,(IF(DMMaize<=35%,35%,IF(DMMaize<=40%,40%,IF(DMMaize<=55%,50%,\"Too high DM\"))))))","v":0.35}]
[null,null,null,null,null,"Miminum density (for less than 3% loss)",null,{"$f":"IF(V4=1,VLOOKUP(H48,AC38:AE41,2),VLOOKUP(H48,AC38:AE41,3))","v":0.17599999999999999},"ton/m3"]
[null,null,null,null,null,"Density of silage",null,{"$f":"IF(AC1=1,H31,H32)","v":0.17316000000000001},"ton/m3"]
[null,null,null,null,null,"Will loss be less than 3% during feedout",null,{"$f":"IF(AND(H50>H49,DMMaize>28%,DMMaize<55%),\"yes\",\"no, increase density\")","v":"no, increase density"}]
[]
[]
[null,null,null,null,null,"Guidelines for \"normal\" storage losses for pile and clamp"]
[null,null,null,null,null,"Storage loss vary a lot and depends very much on dry matter percentage, silage density, and removal rate. Even if best practize is applied and the farm focuses on the lowest possible loss, variations still exisist. "]
[null,null,null,null,null,"Landbrugsinfo, Kvæginfo 2352, 2013: Storage loss at 10 farms from 2009-2011 was followed. The avarage %TS loss for maize was 4-5 %. The lowest loss was 1% for all three years for one farm. The highest observed loss was 12%"]
[null,null,null,null,null,"The storage loss was calculated as diffrence in harvested and ready for feed "]

{"sheet":"Ley","index":6,"n_rows":57,"n_cols":33,"rows_kept":57,"cut":false,"hidden":false,"merged":[[20,1,20,3]]}
["Ley grass, 4 cuts a year, 2 years in a row",null,null,null,null,"I græsproduktion til kvæg bliver føste slæt (ca. 40% af den total produktion) ofte ensileret i stak og dernæst græsser kvæget eller der wrappes. Det skyldes at Det koster det samme per hektar at høste, mens udbyttet per hektar er langt højere ved første slæt end de efterfølgende slæt"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"Beets!A3","v":"Info on biomass"},null,null,null,null,"Clamp silo or bailing?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"Beets!A4","v":"Soil type:"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,true]
[{"$f":"Beets!A5","v":0},null,null,null,null,"Recommended storage",null,{"$f":"IF(C9>80%,\"Bailing\",(IF(C9>60%,\"Wrap Bales\",(IF(C9>45%,\"Bale silage\",IF(C9>30%,\"Clamp silo\",\"Continue drying\"))))))","v":"Continue drying"},null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"Beets!A6","v":"Cultivated area"},null,50,"ha",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[{"$f":"Beets!A7","v":"Yield"},null,30,"ton FM/ha",null,"Clamp silo, transport and field work",null,"Optimal DM 30-35%",null,null,"Storage at farmer",null,null,null,null,"Storage loss",null,null,null,null,null,3]
[{"$f":"Beets!A8","v":"Yield in tonnes"},null,{"$f":"C6*C7","v":1500},"ton FM",null,"Fine cutting, making silage",null,{"$f":"VLOOKUP(Græsjordtype,Græstal,14)","v":-2812},"kr./ha",null,"Volumen grass silage",null,{"$f":"(Leyyield*1000*C9)/DensCalcGrass","v":1185.0421348314605},"m3",null,"Estimated loss during storage",null,null,null,null,"storage",2]
[{"$f":"Beets!A9","v":"Dry matter, %"},null,0.18,null,null,"Means of transport",null,null,null,null,"Volume, clamp silo",null,{"$f":"'Raw data Ley'!F35","v":2160},"m3",null,"Months until delievery",null,6,null,null,null,false]
["KgTS",null,{"$f":"Leyyield*C9*1000","v":270000},"kgTS",null,null,null,null,null,null,"Number of silos",null,{"$f":"M8/M9","v":0.54863061797752799},null,null,"Loss during the first month",null,0.03,"restore",null,null,4]
[null,null,null,null,null,"Road distance",null,15,"km",null,null,null,null,null,null,"Loss per following month",null,5.0000000000000001E-3,"restore",null,null,false]
[{"$f":"Beets!A10","v":"VS , %"},null,{"$f":"0.9*C9","v":0.16200000000000001},{"$f":"0.9*C9","v":0.16200000000000001},null,{"$f":"VLOOKUP(V3,'Raw data Ley'!B26:F27,2)","v":"Tractor dumper"},null,{"$f":"VLOOKUP(V3,'Raw data Ley'!B26:F27,3)","v":-625},"kr./time",null,"Cost Silo",null,{"$f":"'Raw data Ley'!F54","v":-0.12933515757904601},"kr./KgTS",null,"Storage loss",null,{"$f":"Leyyield-(Leyyield*(1-R10)*POWER((1-R11),(LeyLossPeriod-1)))","v":81.013064207671732},"ton",null,null,1]
["Average methane potential",null,null,"L CH4/kg VS",null,"Driving speed",null,{"$f":"VLOOKUP(V3,'Raw data Ley'!B26:F27,4)","v":35},"km/t",null,null,null,null,null,null,"Remaining yield",null,{"$f":"(Leyyield*(1-R10))*POWER(1-R11,(LeyLossPeriod-1))","v":1418.9869357923283},"ton",null,null,2]
[null,null,null,null,null,"Capacity",null,{"$f":"VLOOKUP(V3,'Raw data Ley'!$B$26:$F$27,5)","v":25},"m3/læs"]
[{"$f":"Beets!A13","v":"Cultivation costs"},null,null,null,null,"Capacity",null,{"$f":"DensGrass1*H14","v":7.5},"ton",null,null,null,{"$f":"IF(V9=TRUE,Ex_payment,0)","v":0},"kr/yr",null,"Guidelines for \"normal\" storage losses for pile and clamp"]
["Grass Seeds 1. year",null,{"$f":"VLOOKUP(Græsjordtype,'Raw data Ley'!B17:S22,3)","v":-342},"kr./ha",null,"Volumen, grass (transport)",null,{"$f":"Leyyield/DensGrass1","v":5000},"m3",null,"% usage for grass",null,{"$f":"IF(V9=FALSE,0,Leyyield/Ex_kap*100)","v":0},"%",null,"Storage loss vary a lot and depends very much on dry matter percentage, silage density, and removal rate. Even if best practize is applied and the farm focuses on the lowest possible loss, variations still exisist. "]
["Gras Seeds 2. year",null,0,"kr./ha",null,null,null,null,null,null,"% other usage",null,80,"%",null,"Landbrugsinfo, Kvæginfo 2352, 2013: Storage loss at 10 farms from 2009-2011 was followed. The avarage %TS loss for grass was 4%. The lowest loss was 1-1.5% for all three years for one farm. The highest observed loss was 12%"]
["Fertilizer, N",null,{"$f":"VLOOKUP(Græsjordtype,'Raw data Ley'!B17:S22,4)","v":-1846},"kr./ha",null,null,null,null,null,null,null,null,null,null,null,"The storage loss was calculated as diffrence in harvested and ready for feed "]
["Fertilizer, P",null,{"$f":"VLOOKUP(Græsjordtype,'Raw data Ley'!B17:S22,5)","v":-432},"kr./ha"]
["Fertilizer, K",null,{"$f":"VLOOKUP(Græsjordtype,'Raw data Ley'!B17:S22,6)","v":-1572},"kr./ha",null,"Dry bailing, transport and field work",null,"Optimal DM 80-85%"]
["Manure","no costs"]
[null,null,null,null,null,"Cutting",null,-559,"kr./ha",null,"Storage ",null,null,null,null,"Storage loss"]
[]
[{"$f":"Beets!A22","v":"Machinery costs"},null,null,null,null,null,null,null,null,null,"Yield as bales",null,{"$f":"$C$7/Rundballevægt","v":107.14285714285714},"pcs",null,"Storage loss calculation"]
["Spreading manure",null,{"$f":"VLOOKUP(Græsjordtype,Græstal,9)","v":0},"kr./ha",null,"Bailing",null,-50,"Kr./bale",null,null,null,null,null,null,"Months until delievery",null,6]
["Spreading fertilizer",null,{"$f":"VLOOKUP(Græsjordtype,'Raw data Ley'!B17:S22,10)","v":-399},"kr./ha",null,"Bale weight",null,{"$f":"Normer!M32","v":0.28000000000000003},"ton/bale",null,"Storage at farmer",null,null,null,null,"Storage loss per month",null,5.0000000000000001E-3,"restore",null,null,null,{"$f":"1/18*100","v":5.5555555555555554}]
["Sowing",null,{"$f":"VLOOKUP(Græsjordtype,'Raw data Ley'!B17:S22,11)","v":-190},"kr./ha",null,null,null,null,null,null,null,null,null,null,null,"Storage loss",null,{"$f":"Leyyield*(1-POWER((1-R26),R25))","v":44.4412359656014},"ton",null,null,null,{"$f":"5.56*0.18","v":1.0007999999999999}]
["Mowing",null,{"$f":"VLOOKUP(Græsjordtype,'Raw data Ley'!B17:S22,12)","v":-1100},"kr./ha",null,"Loading",null,null,null,null,"Storage costs at farmer",null,{"$f":"VLOOKUP(V6,TableStoreLey,3)","v":-104},"kr./ton",null,"Remaining yield",null,{"$f":"Leyyield*POWER(1-R26,R25)","v":1455.5587640343986},"ton"]
["Raking",null,{"$f":"VLOOKUP(Græsjordtype,'Raw data Ley'!B17:S22,13)","v":-700},"kr./ha",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ClampGrass/5.56","v":-2.3261718989037054E-2}]
[{"$f":"Beets!A31","v":"Irrigation, fix cost"},null,{"$f":"VLOOKUP(Græsjordtype,'Raw data Ley'!B17:S22,15)","v":0},"kr.",null,null,null,null,null,null,"Storage at facility",null,null,null,null,null,null,null,null,null,null,null,{"$f":"W29*1000","v":-23.261718989037053}]
[{"$f":"Beets!A32","v":"Irrigation, moving of"},null,{"$f":"VLOOKUP(Græsjordtype,'Raw data Ley'!B17:S22,16)","v":0},"kr.",null,{"$f":"IF(V5=1,\"Tractor & frontloader\",(IF(V5=2,\"Telescopic loader\",\"No reload\")))","v":"Tractor & frontloader"},null,{"$f":"IF(V5=1,Normer!H6,(IF(V5=2,BrLoadCost,0)))","v":-650},"kr./time"]
[{"$f":"Beets!A33","v":"Irrigation water, pr mm, average year"},null,{"$f":"VLOOKUP(Græsjordtype,'Raw data Ley'!B17:S22,17)","v":0},"kr.",null,"Loading speed, field",null,{"$f":"IF(V5=1,Normer!H9,(IF(V5=2,BrLoadRoundCap,0)))","v":3.9655172413793105},"min/ton",null,"Storage costs at farmer",null,{"$f":"VLOOKUP(V10,TableStoreLey,3)","v":0},"kr./ton"]
["Other tasks",null,{"$f":"VLOOKUP(Græsjordtype,'Raw data Ley'!B17:S22,18)","v":-500},"kr.",null,"(De)Loading speed, stack",null,{"$f":"IF(V5=1,Normer!H10,(IF(V6=2,BrLoadRoundCap,0)))","v":2.1264367816091956},"min/ton"]
[null,null,null,null,null,null,null,null,null,null,"Pretreatment"]
[null,null,null,null,null,null,null,{"$f":"IF(V11,188,0)","v":0},"kr/ton"]
[null,null,null,null,null,"Transport"]
[null,null,null,null,null,"   ",null,null,null,null,"Pretreatment costs",null,{"$f":"IF(V7=2,Br_Payment,(IF(V7=1,Ex_payment,0)))","v":0},"kr/yr"]
[null,null,null,null,null,null,null,null,null,null,"O&M",null,{"$f":"IF(V7=2,Normer!T15,(IF(V7=1,Normer!S30,0)))","v":0},"kr./ton"]
[null,null,null,null,null,"Road distance",null,10,"km",null,"% usage for grass",null,{"$f":"IF(V7=3,0,Leyyield/Ex_kap*100)","v":0},"%"]
[null,null,null,null,null,{"$f":"VLOOKUP(V4,Tabels!A17:F18,3)","v":"Tractor & trailer"},null,{"$f":"VLOOKUP(V4,Tabels!$A$17:$F$18,4)","v":-675},"kr./hr",null,"% other usage",null,80,"%"]
[null,null,null,null,null,"Capacity, bales",null,{"$f":"IF(V4=1,Normer!$C$19,Normer!$C$8)","v":27},"Bales/load",null,"Tørring?"]
[null,null,null,null,null,"Capacity, tonnes",null,{"$f":"VLOOKUP(V4,TransTableGrass,5)","v":7.5600000000000005},"ton"]
[null,null,null,null,null,"Driving speed",null,{"$f":"VLOOKUP(V4,TransTableGrass,6)","v":25},"km/hr"]
[]
[]
[null,null,null,null,null,"Wrap, transport & field work Optimal DM 35-50%",null,null,null,null,null,null,null,null,null,"Storage included in field work"]
[null,null,null,null,null,"Fine cutting, ",null,{"$f":"LeyCutting","v":-559},"Kr./ha"]
[null,null,null,null,null,"Pressing & wrap",null,-115,"kr./bale",null,"Transport",null,null,null,null,"Storage loss"]
[null,null,null,null,null,"Weight per round bale",null,{"$f":"Normer!M32","v":0.28000000000000003},"ton/bale",null,"   ",null,null,null,null,"Estimated loss during storage"]
[null,null,null,null,null,"Cost per ton",null,{"$f":"H48/H49","v":-410.71428571428567},"kr./ton",null,null,null,null,null,null,"Months until delievery",null,6]
[null,null,null,null,null,null,null,null,null,null,"Road distance",null,10,"km",null,"Loss during the first month",null,0.02,"restore"]
[null,null,null,null,null,"Loading",null,null,null,null,{"$f":"VLOOKUP(V13,Tabels!A17:F18,3)","v":"Tractor & trailer"},null,{"$f":"VLOOKUP(V13,Tabels!$A$17:$F$18,4)","v":-675},"kr./hr",null,"Loss per following month",null,2E-3,"Restore"]
[null,null,null,null,null,null,null,null,null,null,"Capacity, bales",null,{"$f":"IF(V13=1,Normer!$C$19,Normer!$C$8)","v":27},"Bales/load",null,"Storage loss",null,{"$f":"Leyyield-(Leyyield*(1-R51)*POWER((1-R52),(R50-1)))","v":44.641317482446993},"ton"]
[null,null,null,null,null,null,null,null,null,null,"Capacity, tonnes",null,{"$f":"M53*H49","v":7.5600000000000005},"ton",null,"Remaining yield",null,{"$f":"(Leyyield*(1-R51))*POWER(1-R52,(R50-1))","v":1455.358682517553},"ton"]
[null,null,null,null,null,{"$f":"IF(V12=1,\"Tractor & frontloader\",(IF(V12=2,\"Telescopic loader\",\"No reload\")))","v":"Tractor & frontloader"},null,{"$f":"IF(V12=1,Normer!H6,(IF(V12=2,BrLoadCost,0)))","v":-650},"kr./time",null,"Driving speed",null,{"$f":"VLOOKUP(V13,TransTableGrass,6)","v":25},"km/hr"]
[null,null,null,null,null,"Loading speed",null,{"$f":"IF(V12=1,Normer!H9,(IF(V12=2,BrLoadRoundCap,0)))","v":3.9655172413793105},"min/ton"]
[null,null,null,null,null,"(De)Loading speed, stack",null,{"$f":"IF(V12=1,Normer!H10,(IF(V13=2,BrLoadRoundCap,0)))","v":2.1264367816091956},"min/ton"]

{"sheet":"Results Ley","index":7,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
[null,"Ley"]
[]
[null,"End produkt:",{"$f":"VLOOKUP(LeyStoragetype,Tabels!K59:N61,4)","v":"Hay"}]
[]
[]
[null,"Yield",{"$f":"Leyyield","v":1500},"ton"]
[]
[null,"Expected costs"]
[]
[null,"Cultivation & machinery",{"$f":"((SUM((Ley!C16+Ley!C17)/2,Ley!C18:C20)*Ley!C6)/Ley!C8)+((SUM(Ley!C25:C29)*Ley!C6+SUM(Ley!C30:C33))/Leyyield)","v":-214},"kr./ton",null,"ER det ton TS eller ton FM, gå beregninger igennem"]
[null,"Harvest",{"$f":"IF(LeyStoragetype=1,LeyCutClamp/LeyYieldprHA,(IF(LeyStoragetype=2,(Ley!H22/LeyYieldprHA)+(Ley!H25/Ley!H26),Ley!H47/LeyYieldprHA)))","v":-197.20476190476188},"kr./ton"]
[null,"Loading & Transport",{"$f":"IF(LeyStoragetype=1,((Ley!H11/Ley!H13*Ley!H12)/Ley!H15)*2,IF(LeyStoragetype=2,(Ley!H31/60*Ley!H32)+(Ley!H31/60*Ley!H33)+(2*((Ley!H39/Ley!H43*Ley!H40)/Ley!H42)),(Ley!H55/60*Ley!H56)+(Ley!H55/60*Ley!H57)+(2*((Ley!M51/Ley!M55*Ley!M52)/Ley!M54))))","v":-137.42474001094692},"kr./ton"]
[null,"Storage",{"$f":"IF(LeyStoragetype=1,ClampGrass*Ley!C10/Leyyield,(IF(LeyStoragetype=2,Ley!M28+Ley!M32,Ley!H50)))","v":-104},"kr./ton"]
[null,"Pretreatment",{"$f":"IF(Ley!V8=1,(Ley!M15*(Ley!M16/(Ley!M16+Ley!M17))/Leyyield)+(IF(Ley!V9=TRUE,Ex_OandM,0)),(Ley!M37*(Ley!M39/(Ley!M39+Ley!M40))/Leyyield)+Ley!M38)","v":0},"kr./ton",null,"check",null,"Bent Simonsen Maskinstation laver rundballer runde til kvæg til 150-250 kr/balle og wrapballer til 250-300 kr ex levering"]
[null,"Cost in total per ton",{"$f":"SUM(C10:C14)","v":-652.62950191570883},"kr./ton",null,null,null,"Husk at det også indbefatter prisen for græsset"]
[null,"Storage loss",{"$f":"IF(LeyStoragetype=1,1-(Ley!R13/Leyyield),(IF(LeyStoragetype=2,1-(Ley!R28/Leyyield),1-(Ley!R54/Leyyield))))","v":2.9627490643734267E-2}]
[null,"Cost including losses",{"$f":"C15+(C16*C15)","v":-671.9652763775415},"kr./ton"]
[null,"Cost including losses",{"$f":"C17/1000*100/Ley!C9","v":-373.31404243196755},"øre/kgTS",null,null,"Se efter om priserne er realistiske"]
[null,"Total cost",{"$f":"C17*StrawYield","v":-454248.52683121804},"kr."]
[]
[null,"Expected yield (if biogas produced and converted in engine)"]
[]
[null,"Energy yield",{"$f":"IF(Ley!V8=1,(IF(Ley!V9=TRUE,Tabels!M58,Tabels!M57)),VLOOKUP(LeyPretreat,Tabels!K59:M61,3))","v":580.60799999999995},"kWh/ton"]
[null,"- Electricity",{"$f":"$C$23*ElEfficience","v":232.2432},"kWh/ton"]
[null,"- Heat",{"$f":"$C$23*HeatEfficience","v":290.30399999999997},"kWh/ton"]
[null,"Income from electricity",{"$f":"C24*ElCost","v":257.78995200000003},"kr./ton"]
[null,"Income from heat",{"$f":"C25*HeatCost","v":72.575999999999993},"kr./ton"]
[null,"Income per tonne",{"$f":"C26+C27","v":330.36595199999999},"kr./ton"]
[null,"Income from energy",{"$f":"C28*Leyyield","v":495548.92800000001},"kr."]
[]
[]
[null,"Difference, kr",{"$f":"C29+C19","v":41300.401168781973},"kr."]

{"sheet":"Clover max periode","index":8,"n_rows":59,"n_cols":26,"rows_kept":59,"cut":false,"hidden":false,"merged":[[18,2,18,3],[19,2,19,3],[20,2,20,3],[31,1,31,3],[47,1,47,3]]}
["Clover grass BioValue Scenarie max høsteperiode (Torbens slæt), 3-4 cuts a year, 2 years in a row"]
["UNDER REDIGERING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["Production of biomass",null,null,null,null,"Harvest cost",null,null,null,null,null,"Transport of biomass",null,null,null,null,null,null,null,null,1,null,null,1,2]
[]
[{"$f":"Beets!A4","v":"Soil type:"},null,null,null,null,null,"Suggested values",null,null,"My value",null,"Grass transport to press","Suggested values",null,null,"My value",null,"Press cake \"loose\"","Include",null,null,null,null,null,"Tractor, front mower, forest wagon"]
[{"$f":"Beets!A5","v":0},null,null,null,null,"Tractor, front mower & forage wagon",null,null,null,null,null,"Lorry Capacity",55,"m3",{"$f":"IF(P6=0,M6,P6)","v":55},55,null,null,"Suggested values",null,null,"My value",null,null,"High performance mower, forage wagon"]
["Total area",null,null,null,null,"Work width",3.16,"m",{"$f":"IF(J7=0,G7,J7)","v":3.16},null,null,"Density of crop",{"$f":"DensGrass1","v":0.3},"ton/m3",{"$f":"IF(P7=0,M7,P7)","v":0.3},null,null,"Lorry Capacity",55,"m3",{"$f":"IF(V7=0,S7,V7)","v":55},null,null,null,"High performance mower, fine cutter"]
["Area to be harvested 3 times",null,{"$f":"3000-(429*2)","v":2142},"ha",null,"Effective work width",{"$f":"I7*0.7","v":2.2119999999999997},"m",null,null,null,"Ton per load",{"$f":"O7*O6","v":16.5},"ton",{"$f":"IF(P8=0,M8,P8)","v":16.5},null,null,"Density of crop",0.4,"ton/m3",0.5]
["Area to be harvested 4 times",null,{"$f":"429*2","v":858},"ha",null,"Field Speed",10,"km/t",{"$f":"IF(J9=0,G9,J9)","v":10},null,null,"Rental cost",-675,"kr/hr",-675,null,null,"Ton per load",{"$f":"U8*U7","v":27.5},"ton",{"$f":"IF(V9=0,S9,V9)","v":27.5}]
["Yield 1. cuts",null,86204,"ton FM",null,"Capacity",{"$f":"G8*I9/10","v":2.2119999999999997},"ha/t",null,null,null,"Loading",15,"min",15,null,null,"Rental cost",{"$f":"Lorry2trailer","v":-675},"kr/hr",-675]
["Yield 2. cut",null,46041,"ton FM",null,{"$f":"Normer!L15","v":"Tractor w. front mower & wagon"},{"$f":"Normer!M15","v":-1800},"kr/t",-1800,null,null,"Extra transport/waiting",4,"min",4,null,null,"Loading",15,"min",15,null,null,null,{"$f":"24+17+13+8","v":62},{"$f":"Y11-8","v":54}]
["Yield 3. cut",null,46653,"ton FM",null,"Loading to transport wagon",{"$f":"Normer!H6","v":-650},"kr/t",-650,null,null,"Deloading",10,"min",10,null,null,"Extra transport/waiting",4,"min",4]
["Yield 4. cut, 2 blocks",null,5224,"ton FM",null,"In total per cut",{"$f":"(I11/G10)+(I12/G10)","v":-1107.594936708861},"kr/ha",null,null,null,"Average speed",50,"km/hr",52,52,null,"Deloading",10,"min",10]
["Total yield",null,{"$f":"SUM(C10:C13)/(C8+C9)","v":61.374000000000002},"ton FM/ha",null,"In total ",{"$f":"(G13*C18)/CloverYieldprHA","v":-59.301283312564223},"kr/ton",null,null,null,"Round trip",{"$f":"60/O13*2","v":2.3076923076923075},"min/km",null,null,null,"Average speed",50,"km/hr",50]
["Yield in tonnes, 3 cuts",null,136286,"ton FM",null,null,null,null,null,null,null,"Extras",0,"kr",0,null,null,"Round trip",{"$f":"60/U14*2","v":2.4},"min/km"]
["Yield in tonnes, 4 cuts",null,47836,"ton FM",null,null,null,null,null,null,null,"Basic cost",{"$f":"O15+(SUM(O10:O12)*O9/60)","v":-326.25},"kr",null,null,null,"Extras",0,"kr",{"$f":"IF(V16=0,S16,V16)","v":0}]
["Number of cuts ",null,{"$f":"SUM((IF(C10>0,1,0)),(IF(C11>0,1,0)),(IF(C12>0,1,0)),(IF(C13>0,1,0)))","v":4},null,null,"High performance mower & forage wagon",null,null,null,null,null,"Round trip Km cost",{"$f":"O9/O13*2","v":-25.96153846153846},"kr/km",null,null,null,"Basic cost",{"$f":"U16+(SUM(U11:U13)*U10/60)","v":-326.25},"kr"]
["Average number of cuts ",null,{"$f":"C9/(C8+C9)*4+(C8/(C8+C9)*3)","v":3.2859999999999996},null,null,"Work width",13,"m",13,null,null,"Round trip Km cost",{"$f":"M17/O8","v":-1.5734265734265733},"kr/km/ton",null,null,null,"Round trip Km cost",{"$f":"U10/U14*2","v":-27},"kr/km"]
["Dry matter, fresh",null,0.17499999999999999,null,null,"Effective work width",{"$f":"I18*0.6","v":7.8},"m",null,null,null,"Avarage distance",10,"km",{"$f":"IF(P19=0,M19,P19)","v":20},20,null,"Round trip Km cost",{"$f":"S18/U9","v":-0.98181818181818181},"kr/km/ton"]
[{"$f":"Beets!A10","v":"VS , %"},null,{"$f":"0.9*C19","v":0.1575},null,null,"Field Speed",10,"km/t",10,null,null,"In total",{"$f":"M18*O19","v":-31.468531468531467},"kr/ton",null,null,null,"Avarage distance",10,"km",{"$f":"IF(V20=0,S20,V20)","v":10},10]
["Dry matter, after screw press",null,0.6,null,null,"Capacity",{"$f":"G19*I20/10","v":7.8},"ha/t",null,null,null,null,null,null,null,null,null,"In total",{"$f":"S19*U20","v":-9.8181818181818183},"kr/ton"]
["KgTS",null,null,"kgTS",null,"High performance mower",{"$f":"Normer!M16","v":-1800},"kr/t",-1800,null,null,"Grass is divided into liquid & press cake",null,null,null,"Felt: Inkluder ja/nej",null,null,null,null,"videre transport efter presning"]
["TonTS",null,null,"TonTS",null,"Forage wagon pick up",null,null,null,null,null,"Include transport of liquid",null,null,null,null,null,"Press cake \"round bale\", tractor"]
[null,null,null,null,null,"Field speed",8,"km/t",8,null,null,null,null,null,null,null,null,"Bale pressing",{"$f":"Normer!M23","v":-75},"kr/bale"]
[null,null,null,null,null,"Capacity",{"$f":"G19*I24/10","v":6.24},"ha/t",null,null,null,"Liquid transport","Suggested values",null,null,"My value",null,null,{"$f":"S24/S26","v":-65.217391304347828},"kr/ton"]
["Cultivation costs, 3 cuts",null,null,null,null,"Forage wagon pick up",{"$f":"Normer!M17","v":-1600},"kr/t",-1600,null,null,"Lorry Capacity",34,"m3",{"$f":"IF(P26=0,M26,P26)","v":34},null,null,"Bale weight",1.1499999999999999,"ton"]
["Grass Seeds 1. year",null,{"$f":"VLOOKUP(Kløver3jordtype,Clovergrass3cut,3)","v":-346.5},"kr./ha",null,"Loading to transport wagon",{"$f":"Normer!H6","v":-650},"kr/t",-650,null,null,"Density",1,"ton/m3",{"$f":"IF(P27=0,M27,P27)","v":0.8},0.8,null,"Tractor",27,"bales/load"]
["Gras Seeds 2. year",null,0,"kr./ha",null,"In total per cut",{"$f":"(I22/G21)+((I26+I27)/G25)","v":-591.34615384615381},"kr/ha",null,null,null,"Ton per load",{"$f":"O27*O26","v":27.200000000000003},"ton",27.200000000000003,null,null,"Ton per load",{"$f":"S27*S26","v":31.049999999999997},"ton",{"$f":"IF(V28=0,S28,V28)","v":31.049999999999997}]
["Fertilizer, N",null,{"$f":"VLOOKUP(Kløver3jordtype,Clovergrass3cut,4)","v":-1789.2},"kr./ha",null,"In total",{"$f":"(G28*C18)/CloverYieldprHA","v":-31.661020326823429},"kr/ton",null,null,null,"Rental cost",-850,"kr/hr",-850,null,null,"Rental cost",-550,"kr/hr",-550]
["Fertilizer, P",null,{"$f":"VLOOKUP(Kløver3jordtype,Clovergrass3cut,5)","v":-420},"kr./ha",null,null,null,null,null,null,null,"Loading",15,"min",15,null,null,"Loading",15,"min",15]
["Fertilizer, K",null,{"$f":"VLOOKUP(Kløver3jordtype,Clovergrass3cut,6)","v":-1280},"kr./ha",null,null,null,null,null,null,null,"Extra transport/waiting",4,"min",4,null,null,"Extra transport/waiting",4,"min",4]
["Manure","no costs",null,null,null,"High performance mower & fine cutter",null,null,null,null,null,"Deloading",10,"min",10,null,null,"Deloading",10,"min",10]
["Spreading manure",null,{"$f":"VLOOKUP(Kløver3jordtype,Clovergrass3cut,9)","v":0},"kr./ha",null,"Work width",13,"m",13,null,null,"Average speed",50,"km/hr",50,null,null,"Average speed",25,"km/hr",25]
["Spreading fertilizer",null,{"$f":"VLOOKUP(Kløver3jordtype,Clovergrass3cut,10)","v":-399},"kr./ha",null,"Effective work width",{"$f":"I33*0.6","v":7.8},"m",null,null,null,"Round trip",{"$f":"60/O33*2","v":2.4},"min/km",null,null,null,"Round trip",{"$f":"60/U33*2","v":4.8},"min/km"]
["Sowing",null,{"$f":"VLOOKUP(Kløver3jordtype,Clovergrass3cut,11)","v":-190},"kr./ha",null,"Field Speed",10,"km/t",10,null,null,"Extras",0,"kr",{"$f":"IF(P35=0,M35,P35)","v":0},null,null,"Extras",0,"kr",{"$f":"IF(V35=0,S35,V35)","v":0}]
[{"$f":"Beets!A31","v":"Irrigation, fix cost"},null,{"$f":"VLOOKUP(Kløver3jordtype,Clovergrass3cut,15)","v":0},"kr.",null,"Capacity",{"$f":"G34*I35/10","v":7.8},"ha/t",null,null,null,"Basic cost",{"$f":"O35+(SUM(O30:O32)*O29/60)","v":-410.83333333333331},"kr",null,null,null,"Basic cost",{"$f":"U35+(SUM(U30:U32)*U29/60)","v":-265.83333333333331},"kr"]
[{"$f":"Beets!A32","v":"Irrigation, moving of"},null,{"$f":"VLOOKUP(Kløver3jordtype,Clovergrass3cut,16)","v":0},"kr.",null,"High performance mower",{"$f":"Normer!M16","v":-1800},"kr/t",-1800,null,null,"Round trip Km cost",{"$f":"O29/O33*2","v":-34},"kr/km",null,null,null,"Round trip Km cost",{"$f":"U29/U33*2","v":-44},"kr/km"]
[{"$f":"Beets!A33","v":"Irrigation water, pr mm, average year"},null,{"$f":"VLOOKUP(Kløver3jordtype,Clovergrass3cut,17)","v":0},"kr.",null,"Fine cutter & loading",null,null,null,null,null,"Round trip Km cost",{"$f":"M37/O28","v":-1.2499999999999998},"kr/km/ton",null,null,null,"Round trip Km cost",{"$f":"S37/U28","v":-1.4170692431561998},"kr/km/ton"]
["Other tasks",null,{"$f":"VLOOKUP(Kløver3jordtype,Clovergrass3cut,18)","v":-500},"kr.",null,"Fine cutter & loading",-675,"kr/ha",-675,null,null,"Avarage distance",10,"km",{"$f":"IF(P39=0,M39,P39)","v":1},1,null,"Avarage distance",10,"km",{"$f":"IF(V39=0,S39,V39)","v":10}]
["In total",null,{"$f":"(SUM(C36:C39)+(SUM(C27:C31)*C8)+(SUM(C33:C35)*C8))/Clo3Yield","v":-69.546449378512818},"kr./ton",null,"In total per cut",{"$f":"(I37/G36)+I39","v":-905.76923076923072},"kr/ha",null,null,null,"In total",{"$f":"M38*O39","v":-1.2499999999999998},"kr/ton",null,null,null,"In total",{"$f":"S38*U39","v":-14.170692431561998},"kr/ton"]
[null,null,null,null,null,"In total ",{"$f":"(G40*C18)/CloverYieldprHA","v":-48.495416500597834},"kr/ton",null,null,null,"Expected yield 60%",{"$f":"0.6*Cloveryield","v":81771.599999999991},"ton liquid"]
["Cultivation costs, 4 cuts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Press cake \"round bale\", lorry"]
["Grass Seeds 1. year",null,{"$f":"VLOOKUP(Kløver3jordtype,Kløvertal,3)","v":-840},"kr./ha",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bale pressing+wrap",{"$f":"Normer!M23","v":-75},"kr/bale"]
["Gras Seeds 2. year",null,0,"kr./ha",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S43/S45","v":-65.217391304347828},"kr/ton"]
["Fertilizer, N",null,{"$f":"VLOOKUP(Kløver3jordtype,Kløvertal,4)","v":-1789.2},"kr./ha",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bale weight",1.1499999999999999,"ton"]
["Fertilizer, P",null,{"$f":"VLOOKUP(Kløver3jordtype,Kløvertal,5)","v":-432},"kr./ha",null,null,null,null,null,null,null,null,null,null,null,null,null,"Lorry",40,"bales/load"]
["Fertilizer, K",null,{"$f":"VLOOKUP(Kløver3jordtype,Kløvertal,6)","v":-1310},"kr./ha",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ton per load",{"$f":"S46*S45","v":46},"ton",{"$f":"IF(V47=0,S47,V47)","v":46}]
["Manure","no costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rental cost",{"$f":"Lorry2trailer","v":-675},"kr/hr",-675]
["Spreading manure",null,{"$f":"VLOOKUP(Kløver3jordtype,Kløvertal,9)","v":0},"kr./ha",null,null,null,null,null,null,null,null,null,null,null,null,null,"Loading",15,"min",15]
["Spreading fertilizer",null,{"$f":"VLOOKUP(Kløver3jordtype,Kløvertal,10)","v":-399},"kr./ha",null,null,null,null,null,null,null,null,null,null,null,null,null,"Extra transport/waiting",4,"min",4]
["Sowing",null,{"$f":"VLOOKUP(Kløver3jordtype,Kløvertal,11)","v":-190},"kr./ha",null,null,null,null,null,null,null,null,null,null,null,null,null,"Deloading",10,"min",10]
[{"$f":"A36","v":"Irrigation, fix cost"},null,{"$f":"VLOOKUP(Kløver3jordtype,Kløvertal,15)","v":0},"kr.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Average speed",50,"km/hr",50]
["Irrigation, moving of",null,{"$f":"VLOOKUP(Kløver3jordtype,Kløvertal,16)","v":0},"kr.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Round trip",{"$f":"60/U52*2","v":2.4},"min/km"]
["Irrigation water, pr mm, average year",null,{"$f":"VLOOKUP(Kløver3jordtype,Kløvertal,17)","v":0},"kr.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Extras",0,"kr",{"$f":"IF(V54=0,S54,V54)","v":0}]
["Other tasks",null,{"$f":"VLOOKUP(Kløver3jordtype,Kløvertal,18)","v":-500},"kr.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Basic cost",{"$f":"U54+(SUM(U49:U51)*U48/60)","v":-326.25},"kr"]
["In total",null,{"$f":"(SUM(C52:C54)+(SUM(C43:C47)*C9)+(SUM(C49:C51)*C9))/Clo4yield","v":-88.967547453800478},"kr./ton",null,null,null,null,null,null,null,null,null,null,null,null,null,"Round trip Km cost",{"$f":"U48/U52*2","v":-27},"kr/km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Round trip Km cost",{"$f":"S56/U47","v":-0.58695652173913049},"kr/km/ton"]
["Average cultivation cost",null,{"$f":"((C40*Clo3Yield)+(C56*Clo4yield))/(Clo3Yield+Clo4yield)","v":-74.592167150041817},"kr./ton",null,null,null,null,null,null,null,null,null,null,null,null,null,"Avarage distance",10,"km",{"$f":"IF(V58=0,S58,V58)","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In total",{"$f":"S57*U58","v":-5.8695652173913047},"kr/ton"]

{"sheet":"Clover","index":9,"n_rows":59,"n_cols":31,"rows_kept":59,"cut":false,"hidden":false,"merged":[[28,1,28,3],[15,2,15,3],[17,2,17,3],[16,2,16,3]]}
["Clover grass BioValue, 4 cuts a year, 2 years in a row"]
["UNDER REDIGERING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Valgknap skruepresse før transport ja/nej",null,null,null,null,null,null,null,null,null,null,null,null,1]
["Production of biomass",null,null,null,null,"Harvest cost",null,null,null,null,null,"Transport of biomass",null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,3,3,2]
[]
[{"$f":"Beets!A4","v":"Soil type:"},null,null,null,null,null,"Suggested values",null,null,"My value",null,"Grass transport to press","Suggested values",null,null,"My value",null,"Press cake \"loose\"","Include",null,null,null,null,"Press cake \"loose\"","Include",null,null,null,null,null,"Tractor, front mower, forest wagon"]
[{"$f":"Beets!A5","v":0},null,null,null,null,"Tractor, front mower & forage wagon",null,null,null,null,null,"Lorry Capacity",55,"m3",{"$f":"IF(P6=0,M6,P6)","v":48},48,null,null,"Suggested values",null,null,"My value",null,null,"Suggested values",null,null,"My value",null,null,"High performance mower, forage wagon"]
["Cultivated area in total",null,50,"ha",null,"Work width",3.16,"m",{"$f":"IF(J7=0,G7,J7)","v":3.16},null,null,"Densiy of crop",{"$f":"DensGrass1","v":0.3},"ton/m3",{"$f":"IF(P7=0,M7,P7)","v":0.4},0.4,null,"Lorry Capacity",55,"m3",{"$f":"IF(V7=0,S7,V7)","v":55},null,null,"Tractor Capacity",48,"m3",{"$f":"IF(AB7=0,Y7,AB7)","v":48},null,null,null,"High performance mower, fine cutter"]
["Yield 1. cut",null,12,"ton",null,"Effective work width",{"$f":"I7*0.7","v":2.2119999999999997},"m",null,null,null,"Ton per load",{"$f":"O7*O6","v":19.200000000000003},"ton",19.200000000000003,null,null,"Density of crop",0.4,"ton/m3",{"$f":"IF(V8=0,S8,V8)","v":0.4},null,null,"Density of crop",0.4,"ton/m3",{"$f":"IF(AB8=0,Y8,AB8)","v":0.4}]
["Yield 2. cut",null,7,"ton",null,"Field Speed",10,"km/t",{"$f":"IF(J9=0,G9,J9)","v":10},null,null,"Rental cost",{"$f":"Lorry2trailer","v":-675},"kr/hr",-675,null,null,"Ton per load",{"$f":"U8*U7","v":22},"ton",22,null,null,"Ton per load",{"$f":"AA8*AA7","v":19.200000000000003},"ton",19.200000000000003]
["Yield 3. cut",null,6,"ton",null,"Capacity",{"$f":"G8*I9/10","v":2.2119999999999997},"ha/t",null,null,null,"Loading",15,"min",10,10,null,"Rental cost",{"$f":"Lorry2trailer","v":-675},"kr/hr",-675,null,null,"Rental cost",{"$f":"TraktorHalmvogn","v":-675},"kr/hr",-675]
["Yield 4. cut",null,5,"ton",null,{"$f":"Normer!L15","v":"Tractor w. front mower & wagon"},{"$f":"Normer!M15","v":-1800},"kr/t",-1800,null,null,"Extra transport/waiting",4,"min",4,null,null,"Loading",15,"min",15,null,null,"Loading",10,"min",10]
["Yield 5. cut",null,0,"ton",null,"Loading to transport wagon",{"$f":"Normer!H6","v":-650},"kr/t",-650,null,null,"Deloading",10,"min",5,5,null,"Extra transport/waiting",4,"min",4,null,null,"Extra transport/waiting",4,"min",4]
["Total yield",null,{"$f":"SUM(C8:C11)","v":30},"ton/ha",null,"In total per cut",{"$f":"I11/G10+I12/G10","v":-1107.594936708861},"kr/ha",null,null,null,"Average speed",50,"km/hr",25,25,null,"Deloading",10,"min",10,null,null,"Deloading",5,"min",5]
["Yield in tonnes",null,{"$f":"C7*C13","v":1500},"ton",null,"In total ",{"$f":"(G13*C15)/CloverYieldprHA","v":-147.67932489451479},"kr/ton",null,null,null,"Round trip",{"$f":"60/O13*2","v":4.8},"min/km",null,null,null,"Average speed",50,"km/hr",50,null,null,"Average speed",25,"km/hr",25]
["Number of cuts",null,{"$f":"SUM((IF(C8>0,1,0)),(IF(C9>0,1,0)),(IF(C10>0,1,0)),(IF(C11>0,1,0)),(IF(C12>0,1,0)))","v":4},null,null,null,null,null,null,null,null,"Extras",0,"kr",0,null,null,"Round trip",{"$f":"60/U14*2","v":2.4},"min/km",null,null,null,"Round trip",{"$f":"60/AA14*2","v":4.8},"min/km"]
["Dry matter, fresh",null,0.2,null,null,null,null,null,null,null,null,"Basic cost",{"$f":"O15+(SUM(O10:O12)*O9/60)","v":-213.75},"kr",null,null,null,"Extras",0,"kr",{"$f":"IF(V16=0,S16,V16)","v":0},null,null,"Extras",0,"kr",{"$f":"IF(AB16=0,Y16,AB16)","v":0}]
[{"$f":"Beets!A10","v":"VS , %"},null,{"$f":"0.9*C16","v":0.18000000000000002},null,null,"High performance mower & forage wagon",null,null,null,null,null,"Round trip Km cost",{"$f":"O9/O13*2","v":-54},"kr/km",null,null,null,"Basic cost",{"$f":"U16+(SUM(U11:U13)*U10/60)","v":-326.25},"kr",null,null,null,"Basic cost",{"$f":"AA16+(SUM(AA11:AA13)*AA10/60)","v":-213.75},"kr"]
["Dry matter, after skrew press",null,0.6,null,null,"Work width",13,"m",13,null,null,"Round trip Km cost",{"$f":"M17/O8","v":-2.8124999999999996},"kr/km/ton",null,null,null,"Round trip Km cost",{"$f":"U10/U14*2","v":-27},"kr/km",null,null,null,"Round trip Km cost",{"$f":"AA10/AA14*2","v":-54},"kr/km"]
["KgTS",null,{"$f":"Cloveryield*C16*1000","v":300000},"kgTS",null,"Effective work width",{"$f":"I18*0.6","v":7.8},"m",null,null,null,"Average distance",10,"km",5,5,null,"Round trip Km cost",{"$f":"S18/U9","v":-1.2272727272727273},"kr/km/ton",null,null,null,"Round trip Km cost",{"$f":"Y18/AA9","v":-2.8124999999999996},"kr/km/ton"]
["TonTS",null,{"$f":"C19/1000","v":300},"TonTS",null,"Field Speed",10,"km/t",10,null,null,"In total",{"$f":"M18*O19","v":-14.062499999999998},"kr/ton",null,null,null,"Average distance",10,"km",{"$f":"IF(V20=0,S20,V20)","v":10},10,null,"Average distance",5,"km",{"$f":"IF(AB20=0,Y20,AB20)","v":5}]
[null,null,null,null,null,"Capacity",{"$f":"G19*I20/10","v":7.8},"ha/t",null,null,null,null,null,null,null,null,null,"In total",{"$f":"S19*U20","v":-12.272727272727273},"kr/ton",null,null,null,"In total",{"$f":"Y19*AA20","v":-14.062499999999998},"kr/ton"]
[null,null,null,null,null,"High performance mower",{"$f":"Normer!M16","v":-1800},"kr/t",-1800,null,null,"Grass is divided into liquid & press cake",null,null,null,"Felt: Inkluder ja/nej",null,null,null,null,"videre transport efter presning"]
[{"$f":"Beets!A13","v":"Cultivation costs"},null,null,null,null,"Forage wagon pick up",null,null,null,null,null,"Include transport of liquid",null,null,null,null,null,"Press cake \"round bale\", tractor"]
["Grass Seeds 1. year",null,{"$f":"VLOOKUP(Kløverjordtype,Kløvertal,3)","v":-840},"kr./ha",null,"Field speed",8,"km/t",8,null,null,null,null,null,null,null,null,"Bale pressing",{"$f":"Normer!M23","v":-75},"kr/bale"]
["Gras Seeds 2. year",null,0,"kr./ha",null,"Capacity",{"$f":"G19*I24/10","v":6.24},"ha/t",null,null,null,"Liquid transport","Suggested values",null,null,"My value",null,null,{"$f":"S24/S26","v":-65.217391304347828},"kr/ton"]
["Fertilizer, N",null,{"$f":"VLOOKUP(Kløverjordtype,Kløvertal,4)","v":-1789.2},"kr./ha",null,"Forage wagon pick up",{"$f":"Normer!M17","v":-1600},"kr/t",-1600,null,null,"Lorry Capacity",34,"m3",{"$f":"IF(P26=0,M26,P26)","v":34},null,null,"Bale weight",1.1499999999999999,"ton","find ud af hvor mange tons der bliver transporteres og densiteten"]
["Fertilizer, P",null,{"$f":"VLOOKUP(Kløverjordtype,Kløvertal,5)","v":-432},"kr./ha",null,"Loading to transport wagon",{"$f":"Normer!H6","v":-650},"kr/t",-650,null,null,"Densiy of crop",1,"ton/m3",{"$f":"IF(P27=0,M27,P27)","v":1},null,null,"Tractor",27,"bales/load"]
["Fertilizer, K",null,{"$f":"VLOOKUP(Kløverjordtype,Kløvertal,6)","v":-1310},"kr./ha",null,"In total per cut",{"$f":"(I22/G21)+((I26+I27)/G25)","v":-591.34615384615381},"kr/ha",null,null,null,"Ton per load",{"$f":"O27*O26","v":34},"ton",34,null,null,"Ton per load",{"$f":"S27*S26","v":31.049999999999997},"ton",{"$f":"IF(V28=0,S28,V28)","v":31.049999999999997}]
["Manure","no costs",null,null,null,"In total",{"$f":"(G28*C15)/CloverYieldprHA","v":-78.84615384615384},"kr/ton",null,null,null,"Rental cost",-850,"kr/hr",-850,null,null,"Rental cost",550,"kr/hr",550,null,null,null,null,null,null,null,null,11]
["Spreading manure",null,{"$f":"VLOOKUP(Kløverjordtype,Kløvertal,9)","v":0},"kr./ha",null,null,null,null,null,null,null,"Loading",15,"min",15,null,null,"Loading",15,"min",15]
["Spreading fertilizer",null,{"$f":"VLOOKUP(Kløverjordtype,Kløvertal,10)","v":-399},"kr./ha",null,null,null,null,null,null,null,"Extra transport/waiting",4,"min",4,null,null,"Extra transport/waiting",4,"min",4]
["Sowing",null,{"$f":"VLOOKUP(Kløverjordtype,Kløvertal,11)","v":-190},"kr./ha",null,"High performance mower & fine cutter",null,null,null,null,null,"Deloading",10,"min",10,null,null,"Deloading",10,"min",10]
[{"$f":"Beets!A31","v":"Irrigation, fix cost"},null,{"$f":"VLOOKUP(Kløverjordtype,Kløvertal,15)","v":0},"kr.",null,"Work width",13,"m",13,null,null,"Average speed",50,"km/hr",50,null,null,"Average speed",25,"km/hr",25]
[{"$f":"Beets!A32","v":"Irrigation, moving of"},null,{"$f":"VLOOKUP(Kløverjordtype,Kløvertal,16)","v":0},"kr.",null,"Effective work width",{"$f":"I33*0.6","v":7.8},"m",null,null,null,"Round trip",{"$f":"60/O33*2","v":2.4},"min/km",null,null,null,"Round trip",{"$f":"60/U33*2","v":4.8},"min/km"]
[{"$f":"Beets!A33","v":"Irrigation water, pr mm, average year"},null,{"$f":"VLOOKUP(Kløverjordtype,Kløvertal,17)","v":0},"kr.",null,"Field Speed",10,"km/t",10,null,null,"Extras",0,"kr",{"$f":"IF(P35=0,M35,P35)","v":0},null,null,"Extras",0,"kr",{"$f":"IF(V35=0,S35,V35)","v":0}]
["Other tasks",null,{"$f":"VLOOKUP(Kløverjordtype,Kløvertal,18)","v":-500},"kr.",null,"Capacity",{"$f":"G34*I35/10","v":7.8},"ha/t",null,null,null,"Basic cost",{"$f":"O35+(SUM(O30:O32)*O29/60)","v":-410.83333333333331},"kr",null,null,null,"Basic cost",{"$f":"U35+(SUM(U30:U32)*U29/60)","v":265.83333333333331},"kr"]
["In total",null,{"$f":"(SUM(C33:C36)+(SUM(C24:C28)*C7)+(SUM(C30:C32)*C7))/Cloveryield","v":-165.67333333333335},"kr./ton",null,"High performance mower",{"$f":"Normer!M16","v":-1800},"kr/t",-1800,null,null,"Round trip Km cost",{"$f":"O29/O33*2","v":-34},"kr/km",null,null,null,"Round trip Km cost",{"$f":"U29/U33*2","v":44},"kr/km"]
[null,null,null,null,null,"Fine cutter & loading",null,null,null,null,null,"Round trip Km cost",{"$f":"M37/O28","v":-1},"kr/km/ton",null,null,null,"Round trip Km cost",{"$f":"S37/U28","v":1.4170692431561998},"kr/km/ton"]
[null,null,null,null,null,"Fine cutter & loading",-675,"kr/ha",-675,null,null,"Average distance",10,"km",{"$f":"IF(P39=0,M39,P39)","v":10},10,null,"Average distance",10,"km",{"$f":"IF(V39=0,S39,V39)","v":10}]
[null,null,null,null,null,"In total per cut",{"$f":"(I37/G36)+I39","v":-905.76923076923072},"kr/ha",null,null,null,"In total",{"$f":"M38*O39","v":-10},"kr/ton",null,null,null,"In total",{"$f":"S38*U39","v":14.170692431561998},"kr/ton"]
[null,null,null,null,null,"In total ",{"$f":"(G40*C15)/CloverYieldprHA","v":-120.76923076923076},"kr/ton",null,null,null,"Expected yield 60%",{"$f":"0.6*Cloveryield","v":900},"ton liquid"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Press cake \"round bale\", lorry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bale press/wrap",{"$f":"Normer!M23","v":-75},"kr/bale"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S43/S45","v":-65.217391304347828},"kr/ton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bale weight",1.1499999999999999,"ton","find ud af hvor mange tons der bliver transporteres og densiteten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tractor",40,"bales/load",null,"Hvor mange ton må der maksimalt være på en traktor/lastbil"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ton per load",{"$f":"S46*S45","v":46},"ton",{"$f":"IF(V47=0,S47,V47)","v":46}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rental cost",{"$f":"Lorry2trailer","v":-675},"kr/hr",-675]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loading",15,"min",15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extra transport/waiting",4,"min",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deloading",10,"min",10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average speed",50,"km/hr",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Round trip",{"$f":"60/U52*2","v":2.4},"min/km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extras",0,"kr",{"$f":"IF(V54=0,S54,V54)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Basic cost",{"$f":"U54+(SUM(U49:U51)*U48/60)","v":-326.25},"kr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Round trip Km cost",{"$f":"U48/U52*2","v":-27},"kr/km"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Round trip Km cost",{"$f":"S56/U47","v":-0.58695652173913049},"kr/km/ton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average distance",10,"km",{"$f":"IF(V58=0,S58,V58)","v":15},15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In total",{"$f":"S57*U58","v":-8.804347826086957},"kr/ton"]

{"sheet":"Result Clover","index":10,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
[null,"kløver"]
[]
[null,"End produkt:"]
[]
[]
[null,"Yield",{"$f":"Clover!Cloveryield","v":1500},"ton"]
[]
[null,"Expected costs"]
[]
[null,"Cultivation & machinery",{"$f":"((SUM(Clover!C24,Clover!C25)/2)+SUM(Clover!C26:C28)+SUM(Clover!C30:C32))/Clover!CloverYieldprHA+(SUM(Clover!C33:C36)/Clover!C7)","v":-161.34},"kr./ton"]
[null,"Harvest",{"$f":"IF(Clover!AD3=1,Clover!G14,(IF(Clover!AD3=2,Clover!G29,Clover!G41)))","v":-120.76923076923076},"kr./ton"]
[null,"Transport of grass ",{"$f":"Clover!M20","v":-14.062499999999998},"kr./ton"]
[null,"Transport of liquid",{"$f":"Clover!M40","v":-10},"kr./ton"]
[null,"Transport of press cake",{"$f":"IF(Ley!V8=1,(Ley!M15*(Ley!M16/(Ley!M16+Ley!M17))/Leyyield)+(IF(Ley!V9=TRUE,Ex_OandM,0)),(Ley!M37*(Ley!M39/(Ley!M39+Ley!M40))/Leyyield)+Ley!M38)","v":0},"kr./ton"]
[null,"Cost in total per ton",{"$f":"SUM(C10:C14)","v":-306.17173076923075},"kr./ton"]
[null,"Storage loss"]
[null,"Cost including losses",{"$f":"C15","v":-306.17173076923075},"kr./ton"]
[null,"Cost including losses",null,"øre/kgTS"]
[null,"Total cost",{"$f":"C17*StrawYield","v":-206972.09},"kr."]

{"sheet":"Results -straw","index":11,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
["Straw to facility",null,null,null," Decentral briquetting"]
[]
["End produkt:",{"$f":"IF(Straw!$AG$18=TRUE,\"Extruded straw\",(IF(Straw!$AG$19=TRUE,\"Briquetted straw\",\"Straw bale\")))","v":"Straw bale"},null,null,"End product","Briquetted straw"]
[]
[]
["Yield",{"$f":"StrawYield","v":676},"ton",null,null,{"$f":"StrawYield","v":676},"ton"]
[]
["Pretreatment"]
["Antal ekstrudere/briketpressere",{"$f":"IF(Treatment=2,CEILING(StrawYield/BrKap,1),IF(Treatment=1,CEILING(StrawYield/Ex_kap,1),0))","v":0},"stk",null,null,{"$f":"CEILING(StrawYield/PresserKap,1)","v":1},"stk"]
["Samlet kapacitet",{"$f":"IF(Treatment=2,BrKap*AntalEkBr,IF(Treatment=1,Ex_kap*AntalEkBr,0))","v":0},"ton",null,null,{"$f":"PresserKap*BrNumber","v":5800},"ton/år"]
["%-vis udnyttelse til halm",{"$f":"IF(Treatment=3,0,IF(Treatment=1,StrawYield/Ex_kap*100,StrawYield/BrKap*100))","v":11.655172413793103},"%",null,null,{"$f":"Straw!V14","v":11.655172413793103},"%"]
["%-vis udnyttelse, andet",{"$f":"Straw!C66","v":0},"%",null,null,{"$f":"Straw!V15","v":80},"%"]
["Ydelse per  maskine",{"$f":"IF(Treatment=1,Ex_payment,(IF(Treatment=2,Br_Payment,0)))","v":0},"pr. år",null,null,{"$f":"Br_Payment","v":-785398.36415418983},"pr. år"]
["Afskrivning per maskine",{"$f":"IF(Treatment=1,0,IF(Straw!AG4=2,BrTotalCost*Afskrivning,Ex_TotalCost*Afskrivning))","v":{"$error":"#NAME?"}},"pr. år",null,null,{"$f":"(BrTotalCost)*Afskrivning","v":{"$error":"#NAME?"}},"pr. år"]
["OBS! Afskrivning indgår ikke i anskaffelsespris"]
[]
[]
[]
["Expected costs",null,null,null,"Expected costs"]
[]
["Field work incl Pressing",{"$f":"Tedding+Bailing","v":-117.53727810650888},"kr./ton",null,"Pressing",{"$f":"Tedding+Bailing_big","v":-192.33727810650888},"kr./ton",null,{"$f":"B21/7.5","v":-15.67163708086785}]
["Storage at farm",{"$f":"Strawstoragefarm","v":0},"kr./ton",null,"Storage at decentral",{"$f":"Straw!U31+Straw!U40","v":-209.92124697949927},"kr./ton"]
["Storage at facility",{"$f":"Straw!O24+Straw!O33","v":0},"kr./ton",null,"Storage at facility",{"$f":"Straw!U49","v":-117.47111268416008},"kr./ton"]
["Transport & loading",{"$f":"(LoadingRateField*TransportFarmCost/60)+([0]!LoadingSpeedFarm*TransportFarmCost/60)+2*(DistanceFarm*TransportFarmCost/(TractorSpeedRoad*BaleCapTon))+(LoadingSpeedFarm*(TransFacCost+LoadingCostFarm)/60)+(LoadingSpeedFac*(TransFacCost+LoadingCostFac)/60)+2*(DistanceFacility*TransFacCost/(DrivingSpeed*TransFacCap))","v":-87.831915800157034},"kr./ton",null,"Transport",{"$f":"(LoadingRateField*TransportFarmCost/60)+2*(DistFieldToBr*TransportFarmCost/(TractorSpeedRoad*BaleCapTon))+(LoadStore2*TransportFarmCost/60)+(BrLoadCost*BrLoadCap/60)+(BrLoadCap*BrDumperCost/60)+2*(BrDistance*BrDumperCost/(LorrySpeed*BrDumpCapacity))+(BrLoadCap*BrDumperCost/60)","v":-110.96024684523564},"kr./ton",null,{"$f":"B26/7.5","v":-27.382559187555454}]
["Pretreatment",{"$f":"Straw!O11+Straw!O19","v":0},"kr./ton",null,"Pretreatment",{"$f":"Br_Payment*(Straw!V14/(Straw!V14+Straw!V15)/StrawYield)+Br_OandM","v":-223.74235593570162},"kr./ton"]
["Cost in total, per tonne",{"$f":"SUM(B21:B25)","v":-205.36919390666591},"kr./ton",null,"Cost in total, per tonne",{"$f":"SUM(F21:F25)","v":-854.43224055110545},"kr./ton"]
["Storage loss in total",{"$f":"1-(Straw!O37/StrawYield)","v":0},null,null,"Storage loss in total",{"$f":"1-(Straw!U53/StrawYield)","v":2.9970010000001102E-3},null,null,"Bent Simonsen laver halmballer til 300 kr/stk ex levering"]
["Cost including losses",{"$f":"B26+(B26*B27)","v":-205.36919390666591},"kr./ton",null,"Cost including losses",{"$f":"F26+(F27*F26)","v":-856.99297483046939},"kr./ton"]
["Total cost incl losses",{"$f":"B28*StrawYield","v":-138829.57508090616},"kr.",null,"Total cost including losses ",{"$f":"F28*StrawYield","v":-579327.25098539726},"kr."]
[]
[]
["Expected yield (if biogas produced and converted in engine)",null,null,null,"Expected yield (if biogas produced and converted in engine)"]
[]
["Energy yield",{"$f":"IF(Treatment=3, EnergyMethane*VS*MetanHvedehalm,IF(Treatment=2, EnergiMetan*VS*MetanBr, EnergiMetan*VS*MetanEx))","v":2668.0639999999999},"kWh/ton",null,"Energy yield",{"$f":"EnergiMetan*MetanBr*VS","v":2668.0639999999999},"kWh/ton"]
["- Electricity",{"$f":"$B$34*ElEfficience","v":1067.2256},"kWh/ton",null,"- electricity",{"$f":"$F$34*ElEfficience","v":1067.2256},"kWh/ton"]
["- Heat",{"$f":"$B$34*HeatEfficience","v":1334.0319999999999},"kWh/ton",null,"- Heat",{"$f":"$F$34*HeatEfficience","v":1334.0319999999999},"kWh/ton"]
["Income from electricity",{"$f":"B35*ElCost","v":1184.620416},"kr./ton",null,"Income from electricity",{"$f":"F35*ElCost","v":1184.620416},"kr./ton"]
["Income from heat",{"$f":"B36*HeatCost","v":333.50799999999998},"kr./ton",null,"Income from heat",{"$f":"F36*HeatCost","v":333.50799999999998},"kr./ton"]
["Income per tonne",{"$f":"B37+B38","v":1518.128416},"kr./ton",null,"Income per tonne",{"$f":"F37+F38","v":1518.128416},"kr./ton"]
["Income from energy",{"$f":"B39*StrawYield","v":1026254.809216},"kr.",null,"Total income",{"$f":"F39*StrawYield","v":1026254.809216},"kr."]
[]
[]
["Difference, kr",{"$f":"B40+B29","v":887425.23413509387},"kr.",null,"Difference, kr",{"$f":"F40+F29","v":446927.55823060276},"kr."]
[]
[]
["Normale priser for biogasanlæg er 5-600 kr/ton for halm og 450 kr/ton for vraghalm. Vraghalm er relativt dyrt, men det skyldes at det koster noget at skaffe det til veje."]
["How to determine fertiliser value of digestate?"]

{"sheet":"Results rape straw","index":12,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
["Results Rapes"]
[]
["End product:",{"$f":"IF('Rape straw'!AB1=TRUE,\"Extruded straw\",(IF('Rape straw'!AB2=TRUE,\"Briquetted straw\",\"Straw bale\")))","v":"Straw bale"}]
[]
[]
[]
["Expected costs"]
[]
["Field work incl. Pressing",{"$f":"RapeTed+Bailing_big","v":-194.23076923076923},"kr./ton"]
["Storage at farm",{"$f":"'Rape straw'!H19","v":-193.8146462305991},"kr./ton"]
["Storage at facility",{"$f":"RapeFacBalestore+RapeFacBristore","v":0},"kr./ton"]
["Transport & loading",{"$f":"('Rape straw'!C25*RapeTransFarmCost/60)+(RapeLoadSpeedFarm*RapeTransFarmCost/60)+2*(RapeDistanceFarm*RapeTransFarmCost/(TractorSpeedField*RapeFarmCap))+(RapeLoadSpeedFarm*(RapeTransFacCost+RapeLoadFarmCost)/60)+(RapeLoadSpeedFac*(RapeTransFacCost+RapeLoadFacCost)/60)+2*(RapeDistanceToFac*RapeTransFacCost/(RapeDrivingSpeed*RapeTransFacCap))","v":-109.48664624210738},"kr./ton"]
["Pretreatment",{"$f":"(IF('Rape straw'!AB1=TRUE,'Rape straw'!O11,0))+(IF('Rape straw'!AB2=TRUE,'Rape straw'!O19,0))","v":0},"kr./ton",null,"Bent Simonsen laver bigballer af rapshalm til 300 kr/stk ex levering"]
["Cost per ton",{"$f":"SUM(B9:B13)","v":-497.53206170347568},"kr./ton"]
["Storage loss",{"$f":"1-('Rape straw'!O38/RapeYield)","v":0.39364499865599989}]
["Cost including losses",{"$f":"B14+(B14*B15)","v":-693.38306946405714},"kr./ton"]
["Cost in total",{"$f":"B16*RapeYield","v":-450698.99515163712},"kr."]
[]
["Expected yield (if biogas produced and converted in engine)"]
[]
["Energy yield",{"$f":"IF(Rapetreatment=3, EnergiMetan*RapeVS*MethaneRape,IF(Rapetreatment=2, EnergiMetan*RapeVS*MethaenRapeBR, EnergiMetan*RapeVS*MethaneRapeEX))","v":3399.7823999999996},"kWh/ton"]
["- Electricity",{"$f":"$B$21*ElEfficience","v":1359.9129599999999},"kWh/ton"]
["- Heat",{"$f":"$B$21*HeatEfficience","v":1699.8911999999998},"kWh/ton"]
["Income from electricity",{"$f":"B22*ElCost","v":1509.5033856},"kr./ton"]
["Income fra heat",{"$f":"B23*HeatCost","v":424.97279999999995},"kr./ton"]
["Income per tonne",{"$f":"B24+B25","v":1934.4761856},"kr./ton"]
["Total income",{"$f":"B26*RapeYield","v":1257409.52064},"kr."]
[]
["Difference, kr",{"$f":"B27+B17","v":806710.52548836288},"kr."]

{"sheet":"Results  meadow grass","index":13,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,1,2,2],[3,1,3,2]]}
["Results meadow grass"]
[]
["End product",{"$f":"IF('Meadow grass'!AG6=1,\"Round bale, Wrap\",IF('Meadow grass'!AG6=2,\"Round bale, covered\",IF('Meadow grass'!AG6=3,\"Round bale\",\"FAIL\")))","v":"Round bale, Wrap"}]
[null,{"$f":"IF(ExafEng=TRUE,\"Extruded\",\"No pretreatment\")","v":"No pretreatment"}]
[]
["Yield",{"$f":"MeaYield","v":66},"ton"]
[]
[]
[]
["Expected costs",null,null,null," "]
[]
["Harvest, pressing, transport home",{"$f":"MeaHarvestCost/MeaYieldHa","v":-375.81818181818181},"kr./ton",{"$f":"(MeaHarvestCost*'Meadow grass'!C5)/(MeaYield-'Meadow grass'!G17)","v":-511.25333663883646},{"$f":"(D12+B13)*100/1000/0.8","v":-63.906667079854564},"øre/kgTS"]
["Storage, facility",{"$f":"MeaStoreCost","v":0},"kr./ton"]
["Transport, further",{"$f":"IF(MeaDistance>0,2*('Meadow grass'!C39*MeaLoadCost/60)+2*(MeaDistance*MeaTransCost/(MeaTransSpeed*MeaTransCap)),0)","v":-153.21565407772306},"kr./ton"]
["Pretreatment",{"$f":"IF(ExafEng=TRUE,Ex_payment*(MeaExUsedMeaCap/(MeaExUsedMeaCap+'Meadow grass'!M9))/MeaYield+(Ex_OandM),0)","v":0},"kr./ton"]
["Total cost per tonne",{"$f":"SUM(B12:B15)","v":-529.03383589590487},"kr./ton",null,{"$f":"B16*100/1000/0.8","v":-66.129229486988095},"øre/kgTS"]
["Total cost øre/kgTS",{"$f":"B16*100/1000/MeaDM","v":-66.129229486988095},"Øre/kgTS"]
["Total costs",{"$f":"B16*MeaYield","v":-34916.233169129722},"kr.",null,"biogas facility pays 55 øre/kgTS non treated, non stored"]
[]
["Expected yield (if biogas produced and converted in engine)"]
[]
["Energy produced",{"$f":"IF(ExafEng=TRUE,EnergiMetan*MetanEngEx*MeaVS*0.01,EnergiMetan*MetanEng*MeaVS*0.01)","v":19.040000000000003},"kWh/ton",null,null,"Lagertab mangler"]
["- Electricity",{"$f":"$B$22*ElEfficience","v":7.6160000000000014},"kWh/ton"]
["- Heat",{"$f":"$B$22*HeatEfficience","v":9.5200000000000014},"kWh/ton"]
["Income from electricity",{"$f":"B23*ElCost","v":8.4537600000000026},"kr./ton"]
["Income from heat",{"$f":"B24*HeatCost","v":2.3800000000000003},"kr./ton"]
["Total yield per tonne",{"$f":"B25+B26","v":10.833760000000003},"kr./ton"]
["Total yield per tonne",{"$f":"B27*MeaYield","v":715.02816000000018},"kr."]
[]
["Difference",{"$f":"B28+B18","v":-34201.205009129721},"kr."]

{"sheet":"Results beets","index":14,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Results Beets"]
[]
["End product:",{"$f":"VLOOKUP(BeetStorage,'Raw data Beets'!A33:C34,3)","v":"Whole beets"}]
[]
[]
[{"$f":"Beets!A13","v":"Cultivation costs"},{"$f":"SUM(Beets!C14:C18)/BeetFieldYield","v":-70.732558139534888},"kr./ton",null,null,null,{"$f":"B6+B7","v":-124.75581395348837},null,null,null,null,null,null,{"$f":"(B6+B7)/7.5","v":-16.634108527131783}]
["Production and harvest",{"$f":"(SUM(Beets!C23:C31)/BeetFieldYield)+(SUM(Beets!C32:C35)/BeetYield)","v":-54.02325581395349},"kr./ton"]
["Storage",{"$f":"IF(BeetStorage=1,Beets!M13,Beets!M26)","v":-11.377034333847106},"kr./ton"]
["Transport",{"$f":"(2*(CEILING(BeetYield/Beets!H9,1)*(BeetDistPile/Beets!H10)*BeetTransPileCost)+2*(IF(BeetLoadPile=1,(Beets!H16*BeetYield)*(BeetPileLoad/60),BeetPileLoad*BeetYield))+2*(CEILING(BeetYield/Beets!H22,1)*(BeetDistFacility/Beets!H23)*L_Dumper))/BeetYield","v":-29.11627906976744},"kr./ton",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B6:B9)","v":-165.24912735710294}]
[{"$f":"VLOOKUP(BeetClean,'Raw data Beets'!A28:F31,2)","v":"Elephant beet washer"},{"$f":"IF(BeetClean=1,Beets!H38,(IF(BeetClean=2,Beets!H34,0)))","v":-16.429198966408268},"kr./ton"]
["Pulping",{"$f":"IF(BeetStorage=2,BeetPulping,0)","v":0},"kr./ton"]
["Cost per ton",{"$f":"B6+B7+B8+B9+B10+B11","v":-181.67832632351121},"kr./ton",null,{"$f":"B12/7.5","v":-24.223776843134829},"Lemvig biogas pays 1 kr/kgTS for pulp delievered in december",null,null,null,null,null,null,{"$f":"B12/7.5","v":-24.223776843134829},{"$f":"B12/7.5","v":-24.223776843134829}]
["Cost per kgTS",{"$f":"(SUM(B6:B11)/BeetTS)/1000*100","v":-81.470101490363774},"øre/kgTS"]
["Total cost, kr",{"$f":"(B6+B7+B8+B9+B10)*BeetYield","v":-781216.80319109827},"kr.",{"$f":"B14/[1]Roer!C6","v":-15624.336063821966}]
[]
["Expected yield (if biogas produced and converted in engine)"]
[]
["Yield per hektar",{"$f":"Normer!X27*BeetFieldYield*BeetVS","v":6558.8760000000002},"Nm3/ha",null,null,null,null,null,null,{"$f":"(B6+B7+B10)/B12","v":0.77711533223005991}]
[{"$f":"'Results  meadow grass'!A22","v":"Energy produced"},{"$f":"EnergyMethane*Normer!X27*BeetVS","v":854.17920000000004},"kWh/ton"]
[{"$f":"'Results  meadow grass'!A23","v":"- Electricity"},{"$f":"B19*ElEfficience","v":341.67168000000004},"kWh/ton"]
[{"$f":"'Results  meadow grass'!A24","v":"- Heat"},{"$f":"B19*HeatEfficience","v":427.08960000000002},"kWh/ton"]
[{"$f":"'Results  meadow grass'!A25","v":"Income from electricity"},{"$f":"B20*ElCost","v":379.25556480000006},"kr./ton"]
[{"$f":"'Results  meadow grass'!A26","v":"Income from heat"},{"$f":"B21*HeatCost","v":106.7724},"kr./ton",null,null,null,null,"Lagertab mangler"]
[{"$f":"'Results  meadow grass'!A27","v":"Total yield per tonne"},{"$f":"B22+B23","v":486.02796480000006},"kr./ton"]
[{"$f":"'Results  meadow grass'!A28","v":"Total yield per tonne"},{"$f":"B24*BeetYield","v":2089920.2486400004},"kr."]
[]
["Difference, kr/yr",{"$f":"B14+B25","v":1308703.445448902},"kr./yr"]

{"sheet":"Results Maize","index":15,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
["Silage Maize"]
[]
["End produkt:"]
[]
[]
["Yield",{"$f":"Leyyield","v":1500},"ton"]
[]
[]
[]
["Expected costs"]
[null,null,null,"Husk per ton er pr ton vådvægt, så det skal regnes om ved prissammenligninger"]
["Cultivation",{"$f":"(SUM(Maize!C14:C18)*Maize!C6)/MaWetWeight","v":-116.64769647696478},"kr./ton"]
["Maschinery costs, home transport, ensilation",{"$f":"(SUM(Maize!C23:C30)/Maize!C7)+(SUM(Maize!C31:C34)/MaWetWeight)","v":-92.103658536585357},"kr./ton",null,null,"Undersøg om ensilering omfatter selve ensilagestakken, altså folie, vægge med mere?",null,null,null,null,null,null,null,"Det gør det ikke"]
["Transport to facility",{"$f":"2*((MaizeDist/Maize!H8)*MaTransCost)*(Maize!H10/Maize!H9)/MaWetWeight","v":-22.341129744042366},"kr./ton"]
["Storage",{"$f":"Maize!H20","v":-194.4871616857067},"kr./ton"]
["Cost in total, per tonne",{"$f":"SUM(B12:B15)","v":-425.57964644329923},"kr./ton",null,"majsensilage (30%) koster omkring 280 kr/ton jvf Eriks Region Midt analyse, tror det er uden lager"]
["Storage loss in total",{"$f":"1-(Maize!H41/MaWetWeight)","v":5.4008709471781047E-2},null,null,"har også hørt 75-80 øre/FE"]
["Total cost including losses",{"$f":"B16+(B17*B16)","v":-448.56465392515867},"kr./ton"]
["Cost per kgTS",{"$f":"B18/1000*100/DMMaize","v":-131.93078056622312},"øre/kgTS"]
["Total cost",{"$f":"B18*MaWetWeight","v":-529665.14335482731},"kr."]
[null,null,null,null,null,null,{"$f":"B12+B13","v":-208.75135501355015}]
["Expected yield (if biogas produced and converted in engine)"]
[]
["Energy yield",{"$f":"EnergyMethane*Maize!C10*Normer!X28","v":1302.336},"kWh/ton"]
["- Electricity",{"$f":"$B$24*ElEfficience","v":520.93439999999998},"kWh/ton"]
["- Heat",{"$f":"$B$24*HeatEfficience","v":651.16800000000001},"kWh/ton"]
["Income from electricity",{"$f":"B25*ElCost","v":578.23718400000007},"kr./ton"]
["Income from heat",{"$f":"B26*HeatCost","v":162.792},"kr./ton"]
["Income per tonne",{"$f":"B27+B28","v":741.0291840000001},"kr./ton"]
["Income from energy",{"$f":"B29*Maize!C8","v":875007.26046720007},"kr."]
[]
[]
["Difference, kr",{"$f":"B30+B20","v":345342.11711237277},"kr."]

{"sheet":"Transport","index":16,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Transport"]
[]
[]
[]
[]
[]
["Lorry Capacity",null,null,"m3"]
["Densiy of crop",null,null,"ton/m3"]
["Ton transported",null,null,"ton"]
["Rental cost",null,675,"kr/hr"]
["Loading",null,15,"min"]
["Extra transport/waiting",null,4,"min"]
["Deloading",null,10,"min"]
["Average speed",null,50,"km/hr"]
["Round trip",null,{"$f":"60/C14*2","v":2.4},"min/km"]
["Extras",null,0,"kr"]
["Basic cost",null,{"$f":"C16+(SUM(C11:C13)*C10/60)","v":326.25},"kr"]
["Round trip Km cost",null,{"$f":"C10/C14*2","v":27},"kr/km"]

{"sheet":"Straw print","index":17,"n_rows":70,"n_cols":6,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Production cost straw for biogas",null,null,null,null,"Press Ctrl+P for print"]
[{"$f":"\"Printet\"","v":"Printet"},{"$f":"TODAY()","v":"2018-10-26"}]
[]
["Harvest"]
["End product",{"$f":"'Results -straw'!B3:C3","v":"Straw bale"}]
["Transport to farmer",{"$f":"DistanceFarm&\" km using tractor & trailer & frontloader\"","v":"2 km using tractor & trailer & frontloader"}]
["Transport to facility",{"$f":"DistanceFacility&\" km using \"&Straw!A34","v":"5 km using Truck & 2 trailers"}]
["Loading equipment",{"$f":"Straw!A27&\" at farmer, \"&Straw!A42&\" at facility\"","v":"Telescopic loader at farmer, Telescopic loader at facility"}]
[]
[]
["Yield"]
["Yield",{"$f":"Yieldperha&\" Ton/ha.\"","v":"3,38 Ton/ha."}]
["Dry matter",{"$f":"Straw!C7","v":0.89}]
["Ash",{"$f":"Straw!C7-VS","v":3.0000000000000027E-2}]
["Gas potential",{"$f":"VLOOKUP(Treatment,Tabels!K19:M21,3)&\" L CH4/kgVS\"","v":{"$error":"#N/A"}}]
["Gas yield",{"$f":"_xlfn.FLOOR.PRECISE(VLOOKUP(Treatment,Tabels!K19:M21,3)*VS*Yieldperha,1)&\" m3 CH4/ha.\"","v":{"$error":"#N/A"}}]
[]
["Storage"]
["Storage need",{"$f":"_xlfn.FLOOR.PRECISE(Straw!I4,1)&\" m3 bales or \"&_xlfn.FLOOR.PRECISE(Straw!I5,1)&\" m3 briquettes\"","v":"2812 m3 bales or 0 m3 briquettes"}]
["Storage at farmer",{"$f":"\"Bales: \"&Straw!H18","v":"Bales: No storage"}]
["Storage at facility",{"$f":"\"Bales: \"&Straw!#REF!&\". Briquettes: \"&Straw!#REF!","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(Straw!AG5=2,\"Briqeuttes can be stored in barn for bales as bales are being processed\",\"\")","v":""}]
[]
[]
["Pretreatment"]
[{"$f":"IF(Treatment=1,\"Extruding\",(IF(Treatment=2,\"Briquetting\",(IF(Treatment=3,\"none\")))))","v":false}]
[{"$f":"IF(Treatment=3,\"\",\"Yearly cost\")","v":"Yearly cost"},{"$f":"IF(Treatment=1,Ex_payment,(IF(Treatment=2,Br_Payment,(IF(Treatment=3,\"\")))))","v":false}]
[{"$f":"IF(Treatment=3,\"\",\"Cost paid by straw\")","v":"Cost paid by straw"},{"$f":"IF(Treatment=3,\"\",_xlfn.FLOOR.PRECISE(Straw!C65,1)&\" % (straw) and \"&_xlfn.FLOOR.PRECISE(Straw!C66)&\" % (other usage)\")","v":"0 % (straw) and 0 % (other usage)"}]
[]
[]
["Economy"]
["Ecpected costs",{"$f":"_xlfn.FLOOR.PRECISE('Results -straw'!B30,1)","v":0}]
["Expected yield",{"$f":"_xlfn.FLOOR.PRECISE('Results -straw'!B40,1)","v":1026254}]
["Difference",{"$f":"_xlfn.FLOOR.PRECISE('Results -straw'!B43,1)","v":887425}]
[]
[]
[]
[]
[]
["Production cost, straw to biogas, decentral"]
[]
[]
[{"$f":"A4","v":"Harvest"}]
[{"$f":"A5","v":"End product"},"Briquetted straw"]
[{"$f":"A6","v":"Transport to farmer"},{"$f":"DistFieldToBr&\" km using tractor & trailer & frontloader\"","v":"17 km using tractor & trailer & frontloader"}]
[{"$f":"A7","v":"Transport to facility"},{"$f":"BrDistance&\" km using \"&VLOOKUP(Straw!AG7,Tabels!$K$8:$N$10,2)","v":"10 km using Large dump truck"}]
[{"$f":"A8","v":"Loading equipment"},{"$f":"Straw!A27&\" at farmer and \"&Straw!T8&\" at facility\"","v":"Telescopic loader at farmer and Telescopic loader at facility"}]
[]
[{"$f":"A11","v":"Yield"}]
["Yield",{"$f":"Yieldperha&\" Ton/ha.\"","v":"3,38 Ton/ha."}]
["Dry matter",{"$f":"B13","v":0.89}]
["Ash",{"$f":"B14","v":3.0000000000000027E-2}]
["Gas potential",{"$f":"MetanBr","v":277}]
["Gas yield",{"$f":"_xlfn.FLOOR.PRECISE(B53*VS*Yieldperha,1)&\" m3 CH4/ha.\"","v":"805 m3 CH4/ha."}]
[]
[{"$f":"A18","v":"Storage"}]
[{"$f":"A19","v":"Storage need"},{"$f":"B19","v":"2812 m3 bales or 0 m3 briquettes"}]
["Decentral storage",{"$f":"\"Bales: \"&Straw!T31&\". Briquettes: \"&Straw!T40","v":"Bales: Barn, gravel floor. Briquettes: No storage"}]
[{"$f":"A21","v":"Storage at facility"},{"$f":"\"Briquettes: \"&Straw!T49","v":"Briquettes: Barn, concrete floor"}]
[]
[{"$f":"A25","v":"Pretreatment"}]
[{"$f":"A26","v":false}]
[{"$f":"A27","v":"Yearly cost"},{"$f":"Br_Payment","v":-785398.36415418983}]
[{"$f":"A28","v":"Cost paid by straw"},{"$f":"_xlfn.FLOOR.PRECISE(Straw!V14,1)&\" % for straw og \"&_xlfn.FLOOR.PRECISE(Straw!V15)&\"  % others\"","v":"11 % for straw og 80  % others"}]
[]
[]
[{"$f":"A31","v":"Economy"}]
[{"$f":"A32","v":"Ecpected costs"},{"$f":"_xlfn.FLOOR.PRECISE('Results -straw'!F29,1)","v":-579328}]
[{"$f":"A33","v":"Expected yield"},{"$f":"_xlfn.FLOOR.PRECISE('Results -straw'!F40,1)","v":1026254}]
[{"$f":"A34","v":"Difference"},{"$f":"_xlfn.FLOOR.PRECISE('Results -straw'!F43,1)","v":446927}]

{"sheet":"Rape print","index":18,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Production costs for rape straw for biogas"]
[{"$f":"\"Printed d. \"","v":"Printed d. "},{"$f":"TODAY()","v":"2018-10-26"}]
[]
[{"$f":"'Straw print'!A4","v":"Harvest"}]
[{"$f":"'Straw print'!A5","v":"End product"},{"$f":"'Results rape straw'!B3","v":"Straw bale"}]
[{"$f":"'Straw print'!A6","v":"Transport to farmer"},{"$f":"RapeDistanceFarm&\" km using tractor, frontloader, wagon\"","v":"5 km using tractor, frontloader, wagon"}]
[{"$f":"'Straw print'!A7","v":"Transport to facility"},{"$f":"RapeDistanceToFac&\" km with \"&'Rape straw'!A35","v":"5 km with Truck & 2 trailers"}]
[{"$f":"'Straw print'!A8","v":"Loading equipment"},{"$f":"'Rape straw'!A29&\" at farmer and\"","v":"Tractor & Frontloader at farmer and"}]
[null,{"$f":"'Rape straw'!A42&\" at facility\"","v":"Tractor & Frontloader at facility"}]
[]
[{"$f":"'Straw print'!A11","v":"Yield"}]
["Field size",{"$f":"'Rape straw'!C5& \" ha.\"","v":"200 ha."}]
[{"$f":"'Straw print'!A12","v":"Yield"},{"$f":"RapeYield&\" Ton/ha.\"","v":"650 Ton/ha."}]
[{"$f":"'Straw print'!A13","v":"Dry matter"},{"$f":"'Rape straw'!C7","v":0.89}]
[{"$f":"'Straw print'!A14","v":"Ash"},{"$f":"'Rape straw'!C7-'Rape straw'!C8","v":7.4000000000000066E-2}]
[{"$f":"'Straw print'!A15","v":"Gas potential"},{"$f":"_xlfn.FLOOR.PRECISE(VLOOKUP(Rapetreatment,Tabels!K41:M43,3))&\" L CH4/kgVS\"","v":"372 L CH4/kgVS"}]
[{"$f":"'Straw print'!A16","v":"Gas yield"},{"$f":"_xlfn.FLOOR.PRECISE(VLOOKUP(Rapetreatment,Tabels!K41:M43,3)*'Rape straw'!$C$8*'Rape straw'!$C$6,1)&\" m3 CH4/ha.\"","v":"986 m3 CH4/ha."}]
[]
[]
[{"$f":"'Straw print'!A18","v":"Storage"}]
[{"$f":"'Straw print'!A19","v":"Storage need"},{"$f":"_xlfn.FLOOR.PRECISE('Rape straw'!$H$5,1)&\" m3 bales and/or \"&_xlfn.FLOOR.PRECISE('Rape straw'!$H$6,1)&\" m3 briquettes\"","v":"4062 m3 bales and/or 1444 m3 briquettes"}]
[{"$f":"'Straw print'!A20","v":"Storage at farmer"},{"$f":"\"Bales: \"&'Rape straw'!G19","v":"Bales: Open barn"}]
[{"$f":"'Straw print'!A21","v":"Storage at facility"},{"$f":"\"Bales: \"&'Rape straw'!M25","v":"Bales: No storage"}]
[null,{"$f":"\"Briquettes: \"&'Rape straw'!M34","v":"Briquettes: No storage"}]
[]
[{"$f":"'Straw print'!A25","v":"Pretreatment"}]
[{"$f":"'Straw print'!A26","v":false}]
[{"$f":"'Straw print'!A27","v":"Yearly cost"},{"$f":"IF(Rapetreatment=1,Ex_payment,(IF(Rapetreatment=2,Br_Payment,(IF(Rapetreatment=3,\"\")))))","v":-785398.36415418983}]
[{"$f":"'Straw print'!A28","v":"Cost paid by straw"},{"$f":"IF(Rapetreatment=3,\"\",_xlfn.FLOOR.PRECISE('Rape straw'!#REF!,0.1)&\" % for straw and \"&_xlfn.FLOOR.PRECISE('Rape straw'!#REF!)&\"  % other \")","v":{"$error":"#REF!"}}]
[]
[]
[{"$f":"'Straw print'!A31","v":"Economy"}]
[{"$f":"'Straw print'!A32","v":"Ecpected costs"},{"$f":"_xlfn.FLOOR.PRECISE('Results rape straw'!B17,1)","v":-450699}]
[{"$f":"'Straw print'!A33","v":"Expected yield"},{"$f":"_xlfn.FLOOR.PRECISE('Results rape straw'!B27,1)","v":1257409}]
[{"$f":"'Straw print'!A34","v":"Difference"},{"$f":"_xlfn.FLOOR.PRECISE('Results rape straw'!B29,1)","v":806710}]

{"sheet":"meadow grass print","index":19,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Production cost for meadow grass"]
[{"$f":"'Rape print'!A2","v":"Printed d. "},{"$f":"TODAY()","v":"2018-10-26"}]
[]
[{"$f":"'Rape print'!A4","v":"Harvest"}]
[{"$f":"'Rape print'!A5","v":"End product"},{"$f":"'Results  meadow grass'!B4:C4","v":"No pretreatment"}]
[{"$f":"'Rape print'!A6","v":"Transport to farmer"},"Covered by harvest costs"]
["Transport udover 12 km",{"$f":"IF(MeaDistance>0,'Meadow grass'!C29&\" km using \"&'Meadow grass'!A30,\"No\")","v":"15 km using Tractor & trailer"}]
["Transport in field",{"$f":"'Meadow grass'!A22","v":"Tractor"}]
["Loading ",{"$f":"'Meadow grass'!A38","v":"Tractor & frontloader"}]
[]
[{"$f":"'Straw print'!A11","v":"Yield"}]
["Field size",{"$f":"'Meadow grass'!C5&\" ha.\"","v":"12 ha."}]
[{"$f":"'Straw print'!A12","v":"Yield"},{"$f":"MeaYield&\" Ton/ha.\"","v":"66 Ton/ha."}]
[{"$f":"'Straw print'!A13","v":"Dry matter"},{"$f":"'Meadow grass'!C7/100","v":8.0000000000000002E-3}]
[{"$f":"'Straw print'!A14","v":"Ash"},{"$f":"'Meadow grass'!C7-MeaVS&\"%\"","v":"0,12%"}]
[{"$f":"'Straw print'!A15","v":"Gas potential"},{"$f":"IF(ExafEng=TRUE,MetanEngEx,MetanEng)&\" L CH4/KgVs\"","v":"250 L CH4/KgVs"}]
[{"$f":"'Straw print'!A16","v":"Gas yield"},{"$f":"IF(ExafEng=TRUE,(_xlfn.FLOOR.PRECISE(MetanEngEx*'Meadow grass'!C6*MeaVS*0.01,1))&\" m3 CH4/ha\",(_xlfn.FLOOR.PRECISE(MetanEng*'Meadow grass'!C6*MeaVS*0.01,1))&\" m3 CH4/ha\")","v":"9 m3 CH4/ha"}]
[null,"Note: Gas yield is dependend on grass species and harvest time"]
[]
[{"$f":"'Straw print'!A18","v":"Storage"}]
[{"$f":"'Straw print'!A19","v":"Storage need"},{"$f":"CEILING('Meadow grass'!G4,1)&\" pcs round bale\"","v":"236 pcs round bale"}]
[{"$f":"'Straw print'!A20","v":"Storage at farmer"},{"$f":"IF('Meadow grass'!AG7=3,\"no storage/no cover\",(IF('Meadow grass'!AG7=2,\"Covered under presenning\",\"Pomi tubewrap\")))","v":"no storage/no cover"}]
[null,"Note: Stored at facility, only"]
[]
[]
["Pretreatment",{"$f":"IF(ExafEng=TRUE,_xlfn.FLOOR.PRECISE(MeaExUsedMeaCap,1)&\" % meadow grass and \"&_xlfn.FLOOR.PRECISE('Meadow grass'!M9)&\"  % other\",\"\")","v":""}]
[{"$f":"IF(ExafEng=TRUE,\"Extruding\",\"No pretreatment\")","v":"No pretreatment"}]
[]
["Economy"]
["Cost, farmer",{"$f":"_xlfn.FLOOR.PRECISE('Results  meadow grass'!E16)&\" øre/kgTS\"","v":"-67 øre/kgTS"}]
[]
["Expected cost",{"$f":"'Results  meadow grass'!B18","v":-34916.233169129722}]
["Expected yield",{"$f":"'Results  meadow grass'!B28","v":715.02816000000018}]
["Difference",{"$f":"'Results  meadow grass'!B30","v":-34201.205009129721}]

{"sheet":"Beet print","index":20,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Production cost beets for biogas"]
[{"$f":"\"Printet\"","v":"Printet"},{"$f":"TODAY()","v":"2018-10-26"}]
[]
["Harvest"]
["End product",{"$f":"'Results beets'!B3","v":"Whole beets"}]
["Transport from beetlifter to",{"$f":"BeetDistPile&\" km using tractor & dumper\"","v":"1,5 km using tractor & dumper"}]
["Transport to facility",{"$f":"BeetDistFacility&\" km using large Dumper\"","v":"0 km using large Dumper"}]
["Loading equipment at farmer",{"$f":"Beets!F15&\" from pile to dumper\"","v":"Beetloader with dry clean shovel from pile to dumper"}]
[]
[]
["Yield"]
["Yield",{"$f":"BeetFieldYield&\" Ton/ha.\"","v":"86 Ton/ha."}]
["Dry matter",{"$f":"BeetTS","v":0.223}]
["Ash",{"$f":"B13-BeetVS","v":2.2299999999999986E-2}]
["Gas potential",{"$f":"Normer!X27&\" L CH4/kgVS\"","v":"380 L CH4/kgVS"}]
["Gas yield",{"$f":"'Results beets'!B18&\" Nm3/ha \"","v":"6558,876 Nm3/ha "}]
[]
["Storage"]
["Storage need",{"$f":"IF(BeetStorage=1,_xlfn.FLOOR.PRECISE(Beets!M8,1)&\" m3 whole beets\",_xlfn.FLOOR.PRECISE(Beets!M17,1)&\" m3 pulp\")","v":"6142 m3 whole beets"}]
["Storage facilities",{"$f":"IF(BeetStorage=1,CEILING(Beets!M11,1)&\" Clamp silo\",Beets!M19&\" silo size \"&Beets!AF11&\", \"&Beets!M21&\" silo size \"&Beets!AF12)","v":"2 Clamp silo"}]
[]
[]
[]
[]
["Pretreatment"]
[{"$f":"IF(BeetClean=1,\"Elephant beet washer\",(IF(BeetClean=2,\"KWS wet wash\",(IF(Treatment=3,\"no further wash\")))))","v":"Elephant beet washer"}]
[{"$f":"IF(Treatment=3,\"\",\"Yearly cost\")","v":"Yearly cost"},{"$f":"IF(BeetClean=1,_xlfn.FLOOR.PRECISE(Beets!H38,1)&\" kr/ton\",(IF(BeetClean=2,_xlfn.FLOOR.PRECISE(Beets!H34,1)&\" kr/ton\",(IF(BeetClean=3,\"\")))))","v":"-17 kr/ton"}]
[]
[]
[]
["Economy"]
["Expected costs",{"$f":"'Results beets'!B14","v":-781216.80319109827}]
["Expected yield",{"$f":"'Results beets'!B25","v":2089920.2486400004}]
["Difference",{"$f":"B32+B33","v":1308703.445448902}]

{"sheet":"Normer","index":21,"n_rows":52,"n_cols":34,"rows_kept":52,"cut":false,"hidden":false,"merged":[[6,27,8,27],[6,28,8,28],[6,31,8,31],[6,33,8,33],[9,27,11,27],[9,28,11,28],[9,31,11,31],[9,33,11,33]]}
["Forudsætninger"]
[]
[null,"Transport",null,null,null,null,"Loading",null,null,null,null,"Harvest",null,null,null,null,"Pretreatment",null,null,null,null,null,"Gas production",null,null,null,null,"Data fra Operation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Interest",null,0.06,{"$f":"Interest","v":5.5E-2}]
[null,"Collecting bales:","Used values","Suggested vaues",null,null,null,"Used values","Suggested values",null,null,null,"Used values","Suggested values",null,null,"Depreciation",null,0.1,0.1,null,null,"Energy costs",0.6,0.6,"kr/kWh"]
[null,"Tractor and wagon",-675,-675,"kr./hr",null,"Tractor, frontloader",-650,-650,"kr./hr",null,"Bigbale pressing per bale",-80,-80,"kr./bale",null,null,null,null,null,null,null,"Energy of methane",11.2,11.2,"kWh/m3",null,"Front loader","baleweight, kg","bales/load","loading field, min/ha","avarage capacity, min/ha","Aflæsse, min/ha","Gennemsnitlig aflæssekapacitet, min/ha"]
[null,"Capacitet, big square bale",24,24,"Bales/load",null,"Loading, field, round bales",{"$f":"I7","v":23},{"$f":"AF10","v":23},"min/ha",null,"Bigbale pressing per ton",-145,{"$f":"BigbalePressing/BigBaleWeight","v":-145.45454545454544},"kr./ton",null,"Brikketering",null,null,null,null,null,"Estimated methane content",0.62,0.62,null,null,"Round baler",280,12,63,{"$f":"AVERAGE(AE7:AE9)","v":58},34,{"$f":"AVERAGE(AG7:AG9)","v":31.333333333333332}]
[null,"Capacity, round bale (R bale)",27,27,"R bales/load",null,"Deloading, wrap round bale",{"$f":"AH10","v":12.333333333333334},{"$f":"AH10","v":12.333333333333334},"min/ha",null,"Round bale presser (dry biomass) per bale",-50,-50,"kr./bale",null,"Hammer mill, conveyor, shredder",null,-3100000,-3100000,"kr.",null,"Energy content of biogas",{"$f":"X6*X7","v":6.944},{"$f":"Y6*Y7","v":6.944},"kWh/m3",null,null,null,22,56,null,31]
[null,"Capacity, wetland, round bale",12,12,"R bales/load",null,"Loading, field, round bale",{"$f":"I9","v":3.9655172413793105},{"$f":"I7/5.8","v":3.9655172413793105},"min/ton",null,"Round bale presser inkl. Wrap (wet biomass) per bale",-100,-100,"kr./bale",null,"Briket press",null,-1250000,-1250000,"kr.",null,"Efficiency,  electricity ",0.4,0.4,null,null,null,null,44,55,null,29]
[null,null,null,null,null,null,"Deloading, round bale",{"$f":"I10","v":2.1264367816091956},{"$f":"I8/5.8","v":2.1264367816091956},"min/ton",null,"Round bale presser grass BioM",-33,-33,"kr./bale",null,"Installation",null,-373000,-373000,"kr.",null,"Efficiency, heat",0.5,0.5,null,null,"Wrap",700,12,25,{"$f":"AVERAGE(AE10:AE12)","v":23},14,{"$f":"AVERAGE(AG10:AG12)","v":12.333333333333334}]
[null,"Collecting bales",null,null,null,null,"Loading, field, big square bale",9,{"$f":"AF13","v":9},"min/ha.",null,"Round bale Wrap tube",-45,-45,"kr./bale",null,"Briket press, in total",null,-4723000,{"$f":"SUM(T8:T10)","v":-4723000},"kr.",null,"Waste",{"$f":"1-X9-X10","v":9.9999999999999978E-2},{"$f":"1-Y9-Y10","v":9.9999999999999978E-2},null,null,null,null,22,22,null,12]
[null,"Tractor with frontloader and wagon",-675,-675,"kr./hr",null,"Deloading, field, big square bale",7,{"$f":"AH13","v":7},"min/ha",null,"Fine cutter",-1560,-1560,"kr./time",null,"Operation kWh",null,-60,-60,"kWh/ton",null,"Electricity Sales",1.1100000000000001,1.1100000000000001,"kr/kWh",null,null,null,44,22,null,11]
[null,"Capacity,straw bales",24,24,"bales/load",null,"Loading, store, big square bale",{"$f":"I13","v":0.60606060606060597},{"$f":"((40/60)/2)/N26","v":0.60606060606060597},"min/ton",null,"Finsnitter kapacitet - græs",2.7,2.7,"ha./time",null,"Operation",null,-36,{"$f":"T12*Energipris","v":-36},"kr./ton",null,"Heat Sales",0.25,0.25,"kr/kWh",null,"Big bale",550,24,9,{"$f":"AE13","v":9},7,{"$f":"AG13","v":7}]
[null,"Capacity, straw, tonnes",{"$f":"F_kapacitet_baller_1mand*BigBaleWeight","v":13.200000000000001},13,"ton/load",null,"Loading, briquettes",0.6,0.6,"min/ton",null,"Finsnitter kapacitet - majs",2.2999999999999998,2.2999999999999998,"ha./time",null,"Maintanence",null,-40,-40,"kr./ton"]
[null,null,null,null,null,null,null,null,null,null,null,"Tractor w. front mower & wagon",-1800,1800,"kr/time",null,"Operation maintanence (O&M)",null,{"$f":"SUM(S13:S14)","v":-76},{"$f":"SUM(T13:T14)","v":-76},"kr./ton"]
[null,"Road transport",null,null,null,null,"Telescopic loader",-700,-700,"kr./hr",null,"High performance mower",-1800,1800,"kr/time",null,"Ensurance",null,-50000,-50000,"kr./Yr.",null,"Biogasudbytter"]
[null,"Truck & 2 trailers",-675,-675,"kr./hr",null,"Loading, round bale",3.2,{"$f":"24/C8/N32","v":3.174603174603174},"min/ton",null,"Forage Wagon (pick up grass) incl tractor",-1600,1800,"kr/time",null,"Presser capacity",null,5800,5800,"ton/yr",null,"Straw",230,230,"m3 CH4/tonVS",null,{"$f":"Y20*0.23","v":57.5},{"$f":"Y20+AB17","v":307.5},null,"Ny rundballepresser fra Lely: 110-130 baller i timen, bedst 143 baller i timen. 43 rundballer på 2,5 ha på 23 minutter. Gns vægt balle på 480 kg, gns fart for traktir 18 km/t. Maskinen ventes til salg fra 2016"]
[null,"Capacity, big square bales",24,24,"bales/load",null,"Deloading, round bale",3.2,{"$f":"24/C8/N32","v":3.174603174603174},"min/ton",null,"Fine cutter & tractor w wagon",-2700,2700,"kr/time",null,"Service life",null,15,15,"Yr.",null,"Briquettes",277,277,"m3 CH4/tonVS"]
[null,{"$f":"B8","v":"Capacity, round bale (R bale)"},20,20,"R bales/load",null,"Loading, wrap",1.3,{"$f":"24/C8/N35","v":1.2698412698412698},"min/ton",null,"Ilægning i stak",null,"2,3-5,8","ha/time",null,"Interest",null,5.5E-2,{"$f":"Interest","v":5.5E-2},null,null,"Extruded straw",277,277,"m3 CH4/tonVS"]
[null,"Truck & container",-700,-700,"Kr./hr",null,"Deloading, wrap",1.3,{"$f":"24/C8/N35","v":1.2698412698412698},"min/ton",null,"Ensilation/indlægning i stak",-600,-600,"kr./time",null,"Loan Payment, yearly",null,{"$f":"PMT(S19,Br_Servicelife,-BrTotalCost)","v":-470531.6974875232},{"$f":"-PMT(T19,T18,T11)","v":-470531.6974875232},"kr./Yr.",null,"Meadow grass",250,250,"m3 CH4/tonVS"]
[null,"Capacity",15,15,"Ton/load",null,"Loading, square bale",0.82,0.82,"min/ton",null,"Wrapping of silage",null,{"$f":"-100/450*1000","v":-222.2222222222222},"kr./ton",null,"Depreciation 15yrs",null,{"$f":"BrTotalCost/15","v":-314866.66666666669},{"$f":"T11/15","v":-314866.66666666669},"kr./Yr.",null,"Extruded Meadow grass",300,{"$f":"MetanEng*1.2","v":300},"m3 CH4/tonVS",null,{"$f":"50/300","v":0.16666666666666666}]
[null,"Lorry with walking floor",-675,-675,"Kr./hr.",null,"Deloading, square bale",0.82,0.82,"min/ton",null,"Presning af rundballer",-50,null,"kr./stk",null,"Housing",null,-240000,-240000,"kr/Yr.",null,"Ley",320,320,"m3 CH4/tonVS"]
[null,"Capacity",34,34,"Ton/load",null,"Loading/deloading briquettes",{"$f":"BrLoadCap","v":0.6},{"$f":"BrLoadCap","v":0.6},"min/ton",null,"Presning og wrapning",-75,null,"kr./stk",null,"Work force",null,-1860000,-1860000,"kr./Yr.",null,"Extruded or briquetted ley",384,{"$f":"Y22*1.2","v":384},"m3 CH4/tonVS",null,{"$f":"(384-320)/384","v":0.16666666666666666}]
[null,"Tractor that dumps",-625,-625,"Kr./hr",null,null,null,null,null,null,"Weight og Density",null,null,null,null,"Yearly costs",null,{"$f":"S20+S21","v":-785398.36415418983},{"$f":"T21+T20","v":-785398.36415418983},"kr.Yr",null,"Rape straw",310,310,"m3 CH4/tonVS"]
[null,"Capacity",35,35,"m3/load",null,"Tractor, shovel loader",-750,-650,"kr./hr",null,"Adjust used value according to dry matter",null,null,null,null,null,null,null,{"$f":"T24/PresserKap","v":-135.4135110610672},null,null,"Briquetted rape straw",372,{"$f":"Y24*1.2","v":372},"m3 CH4/tonVS"]
[null,"Lorry that dumps",-675,-675,"kr./hr",null,"Deloading dumper, briquettes",3,3,"min/load",null,"Big bale weight",0.55000000000000004,0.55000000000000004,"ton/bale",null,"Extruding",null,null,null,null,null,"Extruded rape straw",372,{"$f":"MethaneRape*1.2","v":372},"m3 CH4/tonVS"]
[null,"Capacity",55,55,"m3/load",null,"Deloading dumper, briquettes",0.14000000000000001,{"$f":"I26/(C27*N39)","v":0.12121212121212122},"min/ton",null,"Density, big bale",0.16,0.16,"ton/m3",null,"Extruder, mixer, and conveyor",null,-5500000,-5500000,"kr.",null,"Beets",380,380,"m3 CH4/tonVS"]
[null,"Blokvogn",-500,-500,"kr/hr",null,null,null,null,null,null,"Compact bale weight",0.5,0.5,"ton/bale",null,"Operation",null,-123,-123,"kWh/ton",null,"Miaze silage",360,360,"m3 CH4/tonVS"]
[null,"Manure transport",-750,-750,"kr/hr",null,"Liquid loading",null,null,null,null,"Density, compact bale",{"$f":"M28/(0.9*1.2*2.4)","v":0.19290123456790123},{"$f":"N28/(0.9*1.2*2.4)","v":0.19290123456790123},"ton/m3",null,"Maintanence",null,-25,-25,"kr./ton"]
[null,"Capacity, Lorry",39,39,"m3/load",null,"Manure loading",13,13,"m3/min",null,"Heavy bale weight",0.9,0.9,null,null,"Operation maintanence (O&M)",null,-98.8,{"$f":"(T28*Energipris)+T29","v":-98.8},"kr./ton",null,"Merudbytte ved brikettering er lidt højere end for ekstrudering, udjævnes ved længere opholdstid. Merudbyttet afhænger af opholdstiden, jo kortere opholdstid, jo større merudbytte ved ex/br."]
[null,"Capacity, tractor with wagon",25,25,"m3/load",null,"Manure unloading",13,13,"m3/min",null,"Density, heavy",{"$f":"M30/(1.3*1.2*2.4)","v":0.24038461538461542},{"$f":"N30/(1.3*1.2*2.4)","v":0.24038461538461542},"ton/m3",null,"Ensurance",null,-50000,-50000,"kr.",null,"Tommelfingerregel: Halm 15 dage: EX +20%, Br +35%.  30 dage: +12% begge. Græs 15 dage +30%, 30 dage +10%. 90 dage alle: Stort set ingen forskel fra ubehandlet"]
[null,"Liquid fodder",-700,-700,"kr/hr",null,"Manure: Cleaning, parking ect. ",5,5,"min",null,"Round bale weight, Ø160",0.28000000000000003,0.28000000000000003,"ton/bale",null,"Capacity",null,10000,10000,"ton/yr"]
[null,"Front wagon",35,35,"m3/load",null,null,null,null,null,null,"Round bale weight Ø180",null,null,null,null,"Service life",null,15,15,"Yr."]
[null,"Second wagon",25,25,"m3/load",null,"Fodder loading",2,2,"m3/min",null,"Density, Round bale",0.2,0.2,"ton/m3",null,"Interest, %",null,5.5E-2,{"$f":"Interest","v":5.5E-2}]
[null,null,null,null,null,null,"Fodder unloading",2,2,"m3/min",null,"Wrap bale weight",0.7,0.7,"ton/bale",null,"Loan term",null,15,15,"Yr."]
[null,"Driving speed",null,null,null,null,"Fodder: Cleaning, parking ect.",5,5,"min",null,"Density, wrap round bale",0.4,0.4,"ton/m3",null,"Loan Payment, yearly",null,{"$f":"PMT(S34,S33,-Ex_TotalCost)","v":-547940.78682646144},{"$f":"-PMT(T34,Ex_Servicelife,T27)","v":-547940.78682646144},"kr./Yr."]
[null,"Tractor, field",15,15,"km/hr",null,null,null,null,null,null,"Density, Grass silage",0.6,0.6,"ton/m3",null,"Depreciation, 20 yrs",null,{"$f":"Ex_TotalCost/20","v":-275000},{"$f":"Ex_TotalCost/20","v":-275000},"kr./Yr."]
[null,"Tractor, road",25,25,"km/hr",null,"TIMELØN",-120,-120,null,null,"Density, fine cut Grass, wetweight",0.3,0.3,"ton/m3",null,"Yearly costs",null,{"$f":"SUM(S36:S37)","v":-822940.78682646144},{"$f":"SUM(T36:T37)","v":-822940.78682646144},"kr./Yr."]
[null,"Lorry, road",51.5,51.5,"km/hr",null,null,null,null,null,null,"Density, briquet",0.45,0.45,"ton/m3",null,null,null,null,{"$f":"T38/Ex_kap","v":-82.294078682646145}]
[null,"Large trailer loaded with beet washer",45,45,null,null,null,null,null,null,null,"Densitet, hele roer",0.7,0.7,"ton/m3",null,"Betacutter/cutting beats"]
[null,null,null,null,null,null,null,null,null,null,null,"Densitet, roepulp",1.2,1.2,"ton/m3",null,"Capacity",null,100,100,"ton/hr"]
[null,null,null,null,null,null,null,null,null,null,null,"Densitet, snittet majs (PASPÅ; KERNEMAJS?)",0.65,0.65,"ton/m3",null,"Investment",null,120000,120000,"kr"]
[null,null,null,null,null,null,null,null,null,null,null,"Densitet majsensilage",0.32,0.32,"ton/m3",null,"Operation",null,{"$f":"(11*X5)/S41","v":6.6000000000000003E-2},{"$f":"(11*Y5)/T41","v":6.6000000000000003E-2},"kr/ton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintanence",null,{"$f":"15000/100000","v":0.15},{"$f":"15000/100000","v":0.15},"kr/ton"]
[null,null,null,null,null,null,null,null,null,null,null,"Economy",null,null,null,null,"Service life ",null,15,15,"Yr."]
[null,"Skamstrup","Brdr. Jacobsen","Skinnerup Maskinstation",null,null,null,null,null,null,null,null,null,null,null,null,"Loan yearly",null,{"$f":"PMT(Interest,S45,S42)","v":-11955.071712577341},{"$f":"PMT(Interest,T45,T42)","v":-11955.071712577341},"kr/yr"]
[null,null,"40 31 66 76","20 16 37 05",null,null,null,null,null,null,null,"Interest",5.5E-2,5.5E-2,"%",null,"Depriciation 15 år",null,{"$f":"-S42/15","v":-8000},{"$f":"-T42/15","v":-8000},"kr/yr"]
[null,null,"uwejacobsen@hotmail.com",null,null,null,null,null,null,null,null,"loan term, maschinery",10,10,"Yr.",null,"Yearly cost",null,{"$f":"SUM(S46:S47)","v":-19955.071712577341},{"$f":"SUM(T46:T47)","v":-19955.071712577341},"kr/yr"]
[null,null,null,null,null,null,null,null,null,null,null,"Loan term, storage",20,20,null,null,"Cost/ton",null,{"$f":"S43+S44","v":0.216},{"$f":"T43+T44","v":0.216},"kr/ton"]
[null,null,null,null,null,null,null,null,null,null,null,"Depreciation",0.04,0.04]
[null,null,null,null,null,null,null,null,null,null,null,"Deprecition periode, storage",30,30,"yr."]
[null,null,null,null,null,null,null,null,null,null,null,"Depreciation periode, maschinery",10,10,"yr."]

{"sheet":"Tabels","index":22,"n_rows":137,"n_cols":38,"rows_kept":137,"cut":false,"hidden":false,"merged":[[49,10,49,16],[48,0,48,7],[25,12,25,13],[27,1,27,5],[0,1,0,5],[0,10,0,16],[28,10,28,16]]}
[null,"Meadow grass",null,null,null,null,null,null,null,null,"Straw"]
[]
[1,"Round bale",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Såning","Tromling","Sprøjtning","Optagning","Vanding","Vanding, flytning","Vanding pr. ml","Øvrige opgaver"]
[2,"Wrapped round bale",null,null,null,null,null,null,null,null,1,"Tractor & Frontloader",{"$f":"Normer!TractorFrontWagon","v":-675},null,"Loading speed",0.61,"min/ton",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,4,1,0,0,0,1]
[3,"Fine cutting",null,null,null,null,null,null,null,null,2,"Telescopic loader",{"$f":"TelescopicLoad","v":-700},null,"Loading speed",{"$f":"LoadTeleBig","v":0.82},"min/ton",null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,4,1,1,2,70,1]
[null,null,null,null,null,null,null,null,null,null,3,"Not to be reloaded",0,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,4,1,0,0,0,1]
[null,"Moist areas","Tractor",-2067,null,null,null,null,null,null,4,"Portable crane",0,"tons",null,0]
[null,"Wet areas","Piste basher vehicle",-3500,null,null,null,null,null,null,1,"Dump truck",-625,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,4,1,0,0,0,1]
[null,null,null,null,null,null,null,null,{"$f":"180/100*80","v":144},null,2,"Large dump truck",-650,48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,4,1,1,2,70,1]
[null,null,"kr./ton",null,null,null,null,null,{"$f":"180/80*100","v":225},null,3,"Truck & container",-575,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,4,1,0,0,0,1]
[1,"Pomi tube wrap",{"$f":"-130/100*80","v":-104},null,null,null,null,null,{"$f":"(0.18/100*80)*1000","v":144},null,null,null,null,"bales/load","compact bales/load"]
[2,"Bales under cover",{"$f":"-180/100*80","v":-144},null,null,null,null,null,null,{"$f":"18*1000/100","v":180},1,"Truck & 2 trailers",{"$f":"Lorry2trailer","v":-675},{"$f":"Normer!C18","v":24},36,{"$f":"LorrySpeed","v":51.5}]
[3,"Open storage",0,null,null,null,null,null,null,null,2,"Tractor & trailer",{"$f":"TraktorHalmvogn","v":-675},{"$f":"Normer!C7","v":24},36,{"$f":"TractorSpeedRoad","v":25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,-475,-160,-200,-1497,0,0,0,-500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"kg",null,"dens (ton/m3)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,-475,-160,-200,-1722,-1130,-110,-70,-500]
[null,null,null,null,null,null,null,null,null,null,1,"Big bales","1.2x1.3x2.4",563,24,{"$f":"N15/(1.2*1.3*2.4)/1000","v":0.15037393162393164},null,null,null,null,null,null,null,null,null,null,null,null,null,null,-500,-160,-200,-1794,0,0,0,-500]
[null,"Transport",null,"Cost","Capacity, ton","Driving speed",null,null,null,null,2,"Flat big bales","1.2x0.9x2.4",500,36,{"$f":"N16/(1.2*0.9*2.4)/1000","v":0.19290123456790123}]
[1,"Truck","Truck & 2 trailers",{"$f":"Lorry2trailer","v":-675},{"$f":"Normer!D19*Rundballevægt","v":5.6000000000000005},{"$f":"LorrySpeed","v":51.5},null,null,null,null,3,"Heavy big bales","1.2x1.3x2.4",900,24,{"$f":"N17/(1.2*1.3*2.4)/1000","v":0.24038461538461539}]
[2,"Tractor","Tractor & trailer",{"$f":"TraktorHalmvogn","v":-675},{"$f":"Normer!D8*Rundballevægt","v":7.5600000000000005},{"$f":"TractorSpeedRoad","v":25},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-475,-160,-200,-1497,0,0,0,-500]
[null,null,null,null,null,null,null,null,null,null,1,"Extruded straw",{"$f":"Normer!Y19","v":277},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-475,-160,-200,-1722,-1130,-110,-70,-500]
[null,null,null,null,null,null,null,null,null,null,2,"Briquetted straw",{"$f":"MetanBr","v":277},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-500,-160,-200,-1700,0,0,0,-500]
[null,null,null,null,null,null,null,null,null,null,3,"Straw bales",{"$f":"MetanHvedehalm","v":230}]
[]
[]
[]
[]
[]
[]
[null,"Dry Storage"]
[null,null,null,null,null,null,null,null,null,null,"Rape straw"]
[null,"      "]
[null,null,null,"Loan, 20 years","Depreciation","Yearly costs","Capacity","Usage",null,null,null,null,"kr./hr"]
[null,null,"Cost, kr.","Yearly payment"," 25 yrs, cost/yr",null,null,null,null,null,1,"Tractor & Frontloader",{"$f":"Normer!TractorFrontWagon","v":-675},null,"Loading speed",{"$f":"LoadStore","v":{"$error":"#NAME?"}},"min/ton"]
[1,"Open barn",1001500,{"$f":"PMT(Interest,loanterm20,C33)","v":-83804.849029985591},{"$f":"C33/25","v":40060},{"$f":"D33-E33","v":-123864.84902998559},5000,0.85,null,null,2,"Telescopic loader",{"$f":"TelescopicLoad","v":-700},null,"Loading speed",{"$f":"LoadTeleBig","v":0.82},"min/ton"]
[2,"Barn, concrete floor",1816500,{"$f":"PMT(Interest,loanterm20,C34)","v":-152003.50300845614},{"$f":"C34/25","v":72660},{"$f":"D34-E34","v":-224663.50300845614},5000,0.85,null,null,null,null,"Kr./hr","tons",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[3,"Barn, gravel floor",1391500,{"$f":"PMT(Interest,loanterm20,C35)","v":-116439.78774360954},{"$f":"C35/25","v":55660},{"$f":"D35-E35","v":-172099.78774360954},5000,0.85,null,null,1,"Dump truck",-625,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[4,"Barn, Cost from handbook2014",1335000,{"$f":"PMT(Interest,loanterm20,C36)","v":-111711.90559663581},{"$f":"C36/25","v":53400},{"$f":"D36-E36","v":-165111.90559663583},5000,0.85,null,null,2,"Large dump truck",-650,48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Container",27000,{"$f":"PMT(Interest,loanterm20,C37)","v":-2259.3419109431961},{"$f":"C37/25","v":1080},{"$f":"D37-E37","v":-3339.3419109431961},37,null,null,null,3,"Truck & container",-575,33]
[null,null,null,null,null,null,null,null,null,null,1,"Truck & 2 trailers",null,{"$f":"Lorry2trailer","v":-675},{"$f":"Normer!C51","v":0},{"$f":"LorrySpeed","v":51.5}]
[null,null,null,"Big bale","Compact bale","Storage loss","Heavy",null,"Briquettes",null,2,"Tractor & trailer",null,{"$f":"TraktorHalmvogn","v":-675},{"$f":"Normer!C40","v":45},{"$f":"TractorSpeedRoad","v":25}]
[null,null,"kr./m3","kr/ton","kr/ton","% ","kr/ton"]
[1,"Open barn",{"$f":"F33/(G33*H33)","v":-29.14467035999661},{"$f":"C41/P15","v":-193.8146462305991},{"$f":"C41/Normer!M29","v":-151.08597114622242},3,{"$f":"C41/P17","v":-121.24182869758589},null,null,null,1,"Extruded rape straw",{"$f":"MethaneRapeEX","v":372}]
[2,"Barn, concrete floor",{"$f":"F34/(G34*H34)","v":-52.862000707872035},{"$f":"C42/P15","v":-351.53699937881504},{"$f":"C42/Normer!M29","v":-274.03661166960865},2,{"$f":"C42/P17","v":-219.90592294474766},1,{"$f":"B42","v":"Barn, concrete floor"},{"$f":"C42/DensBr","v":-117.47111268416008},2,"Briquetted rape straw",{"$f":"MethaenRapeBR","v":372}]
[3,"Barn, gravel floor",{"$f":"F35/(G35*H35)","v":-40.494067704378715},{"$f":"C43/P15","v":-269.28914651011348},{"$f":"C43/Normer!M29","v":-209.92124697949927},2,{"$f":"C43/P17","v":-168.45532165021544},2,"Container",{"$f":"F37/37","v":-90.252484079545837},3,"Rape straw bales",{"$f":"MethaneRape","v":310}]
[4,"POMI Tube wrap",null,{"$f":"-30/BigBaleWeight","v":-54.54545454545454},{"$f":"-22.5/Normer!M28","v":-45},5,{"$f":"-30/N17*1000","v":-33.333333333333336},3,"No storage",0]
[5,"Rick/stack plastic cover",null,{"$f":"-10+(0.5*((timeløn*4+TraktorHalmvogn)/750)/BigBaleWeight)","v":-11.4},{"$f":"-10+(0.5*((timeløn*4+TraktorHalmvogn)/750)/Normer!M28)","v":-11.54},null,{"$f":"-10+(0.5*((timeløn*4+TraktorHalmvogn)/750)/N17)","v":-10.000855555555555}]
[6,"No storage",null,0,0,null,0]
[null,null,null,{"$f":"0.55*0.02","v":1.1000000000000001E-2},0.02]
[null,null,null,null,null,null,null,null,null,"550 kr traktor + mand"]
["Clamp silo for beets",null,null,null,null,null,null,null,null,{"$f":"4*timeløn","v":-480}]
[null,null,null,null,null,null,null,null,null,null,"Ley"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Kr./ton"]
[null,null,null,"Size of Clamp, m","Usage as beet pile, m",null,null,null,null,null,1,"Pomi tube wrap",{"$f":"C11","v":-104},"Clamp silo","Extruded",{"$f":"Ex_payment","v":-822940.78682646144},{"$f":"EnergyMethane*Ley!$C$12*Normer!X23","v":696.7296}]
[null,"Volume","Height",3,5.6,null,null,"Levetid clamp silo",null,null,2,"Open barn",{"$f":"C41/Normer!M34","v":-145.72335179998305},"Bailing","Briquetted",null,{"$f":"EnergyMethane*Ley!$C$12*Normer!X23","v":696.7296}]
[null,null,"Lenght",50,45,null,null,null,null,null,3,"Barn concrete floor",{"$f":"C42/Normer!M34","v":-264.31000353936014},"Wrap","No pretreatment",null,{"$f":"EnergyMethane*Ley!$C$12*Normer!X24","v":562.46400000000006}]
[null,null,"Width",16,15,null,null,null,null,null,4,"No storage costs",0]
[null,"m3 in total",null,{"$f":"D53*D54*D55","v":2400},{"$f":"(12+16)/2*E53*E54","v":3527.9999999999995}]
[null,"m2 plastik + 10%",null,{"$f":"(D54*D55)*1.1","v":880.00000000000011},null,null,null,null,null,null,1,"Ensiled ",{"$f":"EnergyMethane*Ley!C12*Normer!X22","v":580.60799999999995}]
[null,"Cost, concrete ",null,null,null,null,null,null,null,null,2,"Ensiled & extruded",{"$f":"EnergyMethane*Ley!C12*Normer!X23","v":696.7296}]
[null,"L -elements (Walls)","3x1 meter",-2300,"kr",null,null,null,null,null,1,"Extruded",{"$f":"EnergyMethane*Ley!$C$12*Normer!X23","v":696.7296},"Grass silage"]
[null,"Bottom","m2",-500,"kr",null,null,null,null,null,2,"Briquetted",{"$f":"EnergyMethane*Ley!$C$12*Normer!X23","v":696.7296},"Hay"]
[null,null,null,null,null,null,null,null,null,null,3,"No pretreatment",{"$f":"EnergyMethane*Ley!$C$12*Normer!X22","v":580.60799999999995},"Wrap silage"]
[null,"Cost, building a clamp"]
[null,"Bottom",null,null,{"$f":"D60*D54*D55","v":-400000},"kr"]
[null,"walls 2x 50+16",null,null,{"$f":"(46+D54+D55)*D59","v":-257600},"kr"]
[null,"Total",null,null,{"$f":"E63+E64","v":-657600},"kr"]
[null,"Labour + 10 pct",10,null,{"$f":"E65+(E65*C66/100)","v":-723360},"kr"]
[null,"Cover",null,null,{"$f":"-D57*2.5","v":-2200.0000000000005},"kr"]
[null,"Labour for covering","Arbejdstimer",6,{"$f":"6*timeløn","v":-720},"kr",null,null,null,null,null,"Overdækning plansilo"]
[null,"Total cost",null,null,{"$f":"E66+E67+E68","v":-726280},"kr",null,null,null,null,null,"Megaplast fra Compex, brug et lag","2,5 kr/m2"]
[null,"Yearly cost for storage of beets"]
[null,"Yearly cost, loan 20 years",null,null,{"$f":"-PMT(Interest,loanterm20,SiloCost)","v":-60774.62381777128},"kr"]
[null,"Yearly cost, depriciation 20 years",null,null,{"$f":"E69/20","v":-36314},"kr"]
[null,"yearly cost, in total",null,null,{"$f":"E71-E72","v":-24460.62381777128},"kr"]
[null,"Yearly cost/m3",null,null,{"$f":"E73/E56","v":-6.9332833950598873},"kr/m3"]
[null,"Beet Weight, standard numbers",{"$f":"Roedensitet","v":0.7},"tons/m3",null,null,"If Clamp is NOT fully used"]
[null,"Yearly cost/ton",null,null,{"$f":"E74/C75","v":-9.9046905643712684},"kr/ton",{"$f":"(E73*Beets!M12)/BeetYield","v":-11.377034333847106},"kr/ton"]
[null,"Yearly cost/tonTS",{"$f":"BeetTS","v":0.223},null,{"$f":"E76/C77","v":-44.415652755028106},"kr/ton TS",{"$f":"G76/C77","v":-51.018091183170881},"kr/ton TS"]
[null,"Yearly cost/kgTS",null,null,{"$f":"E77/1000","v":-4.4415652755028102E-2},"kr/kgTS",{"$f":"G77/1000","v":-5.1018091183170883E-2},"kr/kgTS"]
[null,null,null,null,null,null,null,null,null,"r d"]
[]
[]
[]
[null,"Average density of silage "]
[null,"Bunker Silo with or without Rounded Top Surface"]
[]
[null,"="]
[null,"Silage DM (60-70% is typical)",null,null,65,"%","indtast",65,"%"]
[null,"Days of feed out",null,null,10,null,"indtast",9]
[null,"Total weight of silage removed ",null,null,57650,"kg","indtast",{"$f":"2.2046*E89","v":127095.19},"lb"]
[]
[null,"Length of Silage Removed ",null,null,1.8,"m","indtast",{"$f":"E91/0.3048","v":5.9055118110236222},"ft"]
[null,"Bottom Width of Bunker  ",null,null,12.2,"m","indtast",{"$f":"E92/0.3048","v":40.026246719160099},"ft"]
[null,"Silage Depth-Measured from Floor to Bottom of Domed Silage",null,null,3,"m","indtast",{"$f":"E93/0.3048","v":9.8425196850393704},"ft"]
[null,"Dome Height  above Silage Depth = Maximum silage height minus Pile Depth.",null,null,1,"m","indtast",{"$f":"E94/0.3048","v":3.280839895013123},"ft"]
[null,"       Use Dome Height = 0.01 when silage is level on top."]
[null,"Top Width Measured at Bottom of Domed Silage",null,null,13,"m","indtast",{"$f":"E96/0.3048","v":42.650918635170605},"ft",null,null,"Feeout 8-11 cm","nederste tabel"]
[null,null,null,null,null,null,null,null,null,null,null,"Feedout 12-19 cm ","midterste tabel"]
[null,"-------------------------------------------------------------------",null,null,null,null,null,null,null,null,null,"Feedout 19 cm og over","øverst"]
[null,"Calculated Volume of Feed Removed",null,null,{"$f":"E105+E109","v":83.713598411731311},"m3",null,{"$f":"H105+H109","v":2956.317827966815}]
[null,"Average Density of Stored Silage",null,null,{"$f":"E89/E99","v":688.65753107945659},"kg/m3",null,{"$f":"H89/H99","v":42.991044060850776},null,null,null,"DM under 30 behandles ikke"]
[null,"Average Dry Matter Density of Stored Silage ",null,null,{"$f":"E100*(100-E87)/100","v":241.03013587780981},"kg DM/m3",null,{"$f":"H100*(100-H87)/100","v":15.04686542129777},"lbsDM/cu ft",null,null,"30-32,5 ","se 30"]
[null,"Feedout Rate",null,null,{"$f":"E91*100/E88","v":18},"cm/dag",null,{"$f":"H91*12/H88","v":7.8740157480314963},"min 6 inch per day",null,null,"32,5-37.5","se 35"]
[null,"-------------------------------------------------------------------",null,null,null,null,"Anbefales minimum 15 cm per dag",null,null,null,null,"37,5 til 45","se 40"]
[null,"Area Within Bunker Walls ",null,null,{"$f":"((E92+E96)/2)*E93","v":37.799999999999997},"m2",null,{"$f":"((H92+H96)/2)*H93","v":406.87581375162745},null,null,null,"45-55","se 50"]
[null,"Volume of silage below the silage dome",null,null,{"$f":"E91*E104","v":68.039999999999992},"m3",null,{"$f":"H91*H104","v":2402.8099237300835},null,null,null,"Over 50 behandles ikke"]
[null,"Radius of Silage Dome",null,null,{"$f":"(E96^2/(8*E94))+(E94/2)","v":21.625},"m",null,{"$f":"(H96^2/(8*H94))+(H94/2)","v":70.948162729658804}]
[null,"Radius minus Dome Height",null,null,{"$f":"E106-E94","v":20.625},"m",null,{"$f":"H106-H94","v":67.667322834645688},null,null,null,"DM density: Lav kurve"]
[null,"Cross section area of silage in the silage dome",null,null,{"$f":"(E106^2*ACOS(E107/E106))-E107*0.5*E96","v":8.7075546731840632},"m2",null,{"$f":"(H106^2*ACOS(H107/H106))-H107*0.5*H96","v":93.727338450753223}]
[null,"Volume of silage in the silage dome",null,null,{"$f":"E108*E91","v":15.673598411731314},"m3",null,{"$f":"H108*H91","v":553.50790423673163}]
[]
[]
[]
[]
[null,"removal dry matter loss according to pitt and muck 1993/1994"]
[]
["9 inch","9inch=22,86cm",null,null,null,null,"tab på grund af bundmateriale i bunker: 4-6% for asfalt, 6-8 % for macadam. 8-20% for jord, 3-5% for beton (normal)"]
["lbsDM/ft",30,35,40,50,"DM","ilde: Preventing silage storage losses af Brian Holmes og Richard Muck http://fyi.uwex.edu/forage/files/2014/01/prevent-silage-storage7.pdf"]
[10,2.9,3.1,3.6,4,"tab%"]
[15,1.4,2,2.5,3.2,"tab%"]
[20,0.1,1,1.5,2.2999999999999998,"tab%"]
[25,null,null,0.8,1.9,"tab%"]
[]
["15,24cm"]
["dens",30,35,40,50,"dm"]
[10,3.8,4,4.5,5.0999999999999996,"tab%"]
[15,2,2.8,3.2,4.2,"tab%"]
[20,0.1,1.2,2,2.8,"tab%"]
[25,null,null,1,2.2000000000000002,"tab%"]
["7,62cm"]
["dens",30,35,40,50]
[10,7.1,8.1,9.1,10.1]
[15,4,5.5,6.8,8.5]
[20,0.5,2.8,4.0999999999999996,6.8]
[25,null,null,1.9,4.8]
[]
[null,"Density and feedout rate affect amount of air exposure prior to use. In loosely packed silage, oxygen pentrates deeply into the silage from the open face"]
[null,"Feed out rate (cm removed/day) influence avarage loss. If only 5 cm is removed every day and ex 10% er lost of the first 5 cm then all of the silage will have some loss, if 20 cm was removed every day, then 5 cm will have 10% loss and the remaining 15 cm will have leeser loss. if no loss after 5 cm, then avarage loss would be 2.5% instead of 10%"]

{"sheet":"Raw data Beets","index":23,"n_rows":53,"n_cols":20,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["(Fodder)Roer"]
[null,"Opdateret fra Farmtal online 10-11-2017"]
[null,null,"Seeds","N","P","K","Manure","Weeds/disease","Ploughing","Harrowing","Spredding manure","Fertilizer spreading","Sowing","Rolling","Spred pestizide","Harvest","Watering","watering, moving of","watering pr. ml","Other tasks"]
[null,"JB 1-3",1,190,23,213,0,1,1,2,1,1,1,1,6,1,0,0,0,1]
[null,"JB 1-4 + watering",1,224,29,280,0,1,1,2,1,1,1,1,6,1,1,2,5,1]
[null,"JB 5-6",1,209,30,281,0,1,1,2,1,1,1,1,6,1,0,0,0,1]
[null,"JB 1-3+ manure",1,64,0,0,40,1,1,2,-40,1,1,1,6,1,0,0,0,1]
[null,"JB 1-4 + manure+ water",1,98,0,0,40,1,1,2,-40,1,1,1,6,1,1,2,5,1]
[null,"JB 5-6 + manure + water",1,83,0,0,40,1,1,2,-40,1,1,1,6,1,0,0,0,1]
[]
[null,"JB 1-3",-1300,-6.3,-12,-5,0,-2245,-608,-152,0,-133,-523,-165,-215,-1613,0,0,0,-500]
[null,"JB 1-4 m. watering",-1300,-6.3,-12,-5,0,-2245,-608,-152,0,-133,-523,-165,-215,-1862,-1200,-120,-70,-500]
[null,"JB 5-6",-1300,-6.3,-12,-5,0,-2245,-675,-160,0,-140,-550,-165,-215,-1938,0,0,0,-500]
[null,"JB 1-3 with manure",-1300,-6.3,"-","-",0,-2245,-608,-152,20,-133,-523,-165,-215,-1613,0,0,0,-500]
[null,"JB 1-4 m. manure and watering",-1300,-6.3,"-","-",0,-2245,-608,-152,20,-133,-523,-165,-215,-1862,-1200,-120,-70,-500]
[null,"JB 5-6 m. manure",-1300,-6.3,"-","-",0,-2245,-675,-160,20,-140,-550,-165,-215,-1938,0,0,0,-500]
[]
[1,"JB 1-3",{"$f":"C4*C11","v":-1300},-1197,-276,-1065,0,-2245,-608,-304,0,{"$f":"L4*L11","v":-133},-523,-165,-1290,-1613,0,0,0,-500]
[2,"JB 1-4 + watering",-1300,-1411.2,-348,-1400,0,-2245,-608,-304,0,{"$f":"L5*L12","v":-133},-523,-165,-1290,-1862,-1200,-240,-350,-500]
[3,"JB 5-6",-1300,-1316.7,-360,-1405,0,-2245,-675,-320,0,{"$f":"L6*L13","v":-140},-550,-165,-1290,-1938,0,0,0,-500]
[4,"JB 1-3 + manure",{"$f":"C7*C14","v":-1300},-403.2,0,0,{"$f":"G7*G14","v":0},-2245,-608,-304,-800,{"$f":"L7*L14","v":-133},-523,-165,-1290,-1613,0,0,0,-500]
[5,"JB 1-4 + manure and watering",-1300,-617.4,0,0,0,-2245,-608,-304,-800,{"$f":"L8*L15","v":-133},-523,-165,-1290,-1862,-1200,-240,-350,-500]
[6,"JB 5-6 + manure",-1300,-522.9,0,0,0,-2245,-675,-320,-800,{"$f":"L9*L16","v":-140},-550,-165,-1290,-1938,0,0,0,-500]
[]
[]
[null,null,null,"Capacity","water","water"]
[null,null,"kr./hr.","ton/hr.","L/ton","kr./ton beet"]
[1,"Elephant beet washer",{"$f":"[1]Forudsætninger!M32","v":-1120},{"$f":"[1]Forudsætninger!M33","v":70},{"$f":"[1]Forudsætninger!M34","v":50},{"$f":"E28*[1]Forudsætninger!V9","v":-0.3}]
[2,"KWS wet wash",{"$f":"[1]Forudsætninger!M35","v":-1120},{"$f":"[1]Forudsætninger!M36","v":50},{"$f":"[1]Forudsætninger!M37","v":40},{"$f":"E29*[1]Forudsætninger!V9","v":-0.24}]
[3,"No further cleaning"]
[null,"Thyregod dry washing"]
[]
[1,"Whole beets/silage pit","Whole beets"]
[2,"Beet pulp","Beet pulp"]
[null,null,null,null,null,null,null,null,"Building","Coating/cover"]
[null,"Silos","m3","Cost","Tank coating","Cover","Preparing","Total costs","Interest, %","Service life/Yr","Service life/Yr","Yearly payment","Kr/m3"]
[1,1,2000,210420,106080,128000,{"$f":"25080+2500","v":27580},{"$f":"SUM(D37:G37)","v":472080},{"$f":"Interest","v":5.5E-2},{"$f":"loanterm20","v":20},10,{"$f":"PMT(I37,J37,H37)","v":-39503.338122891262},{"$f":"L37/C37","v":-19.751669061445632}]
[2,2,3000,270914,148590,148000,{"$f":"31086+3500","v":34586},{"$f":"SUM(D38:G38)","v":602090},{"$f":"Interest","v":5.5E-2},{"$f":"loanterm20","v":20},10,{"$f":"PMT(I38,J38,H38)","v":-50382.487820732924},{"$f":"L38/C38","v":-16.794162606910973}]
[3,3,4000,323900,187460,165000,{"$f":"39600+4500","v":44100},{"$f":"SUM(D39:G39)","v":720460},{"$f":"Interest","v":5.5E-2},{"$f":"loanterm20","v":20},10,{"$f":"PMT(I39,J39,H39)","v":-60287.610116967968},{"$f":"L39/C39","v":-15.071902529241992}]
[4,4,5000,415500,202020,175000,{"$f":"42000+4500","v":46500},{"$f":"SUM(D40:G40)","v":839020},{"$f":"Interest","v":5.5E-2},{"$f":"loanterm20","v":20},10,{"$f":"PMT(I40,J40,H40)","v":-70208.631485909646},{"$f":"L40/C40","v":-14.041726297181929}]
[]
[null,null,"pris"]
[1,"Shovel loader",{"$f":"[1]Forudsætninger!I29","v":-675},{"$f":"[1]Forudsætninger!I30","v":0.56000000000000005}]
[2,"Beetloader with dry clean shovel",{"$f":"[1]Forudsætninger!I26","v":-12},{"$f":"[1]Forudsætninger!I27","v":0.1}]
[]
[]
[]
[null,"Elephant beet washer, kr/time",-1120]
[null,"Kapacitet, ton/time",70]
[null,"Vandforbrug, L/ton",50]
[null,"KWS vådvasker, kr/time",-1120]
[null,"Kapacitet, ton/time",50]
[null,"Vandforbrug, L/ton",40]

{"sheet":"Cases Eng","index":24,"n_rows":108,"n_cols":4,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["meadow grass case",null,null,"Note: Some calculations needs to be recalculated if entries in original sheets are chamges"]
[]
[]
["Facility pays 55 øre/kg TS, græs"]
[]
[]
[]
[]
[]
["From Meadow grass sheet"]
[]
["Opdyrket areal",{"$f":"'Meadow grass'!C5","v":12},{"$f":"'Meadow grass'!D5","v":"ha."}]
["Yield",{"$f":"'Meadow grass'!C6","v":5.5},{"$f":"'Meadow grass'!D6","v":"ton/ha."}]
["Dry matter",{"$f":"'Meadow grass'!C7","v":0.8},{"$f":"'Meadow grass'!D7","v":"%"}]
["Organic matter - VS/TS",{"$f":"'Meadow grass'!C8","v":0.68},{"$f":"'Meadow grass'!D8","v":"%"}]
["Bale weight",{"$f":"'Meadow grass'!C9","v":0.28000000000000003},{"$f":"'Meadow grass'!D9","v":"ton/bale"}]
["Transport udover 12 km",{"$f":"IF(MeaDistance>0,'Meadow grass'!C29&\" km using \"&'Meadow grass'!A30,\"No\")","v":"15 km using Tractor & trailer"}]
[]
["Meadow wetness",{"$f":"IF('Meadow grass'!AG3=1,\"Moist meadow\",\"Wet meadow\")","v":"Moist meadow"}]
["Storage",{"$f":"IF('Meadow grass'!AG7=3,\"No storage/open storage\",(IF('Meadow grass'!AG7=2,\"Covered by pressenning\",\"Pomi tubewrap\")))","v":"No storage/open storage"}]
[]
[]
["Case 1: No extrusion, open storage of round bales, transportation less than 12 km."]
["Facility pays 55 øre/kgTS, which yield is needed?"]
[]
["55 øre/kgTS equals",{"$f":"0.55*1000","v":550},"kr/tonTS"]
["55 øre/kgTS equals",{"$f":"B26*B14/100","v":4.4000000000000004},"kr/ton"]
[]
["yield/ ha.","kr/ton"]
[1,2067]
[3,689]
[5,413]
[7,295]
[10,207]
[]
["Minimums  yield is",{"$f":"2069*B27^-1","v":470.22727272727269},"ton/ha."]
[]
[]
[]
[]
[]
[]
[]
[]
["Case 2: No extrusion, open storage, 20 km transport by tractor"]
["Hvad skal udbyttet være for at prisen på 55 øre/kgTS opnås?"]
[]
["Yield/ ha.","kr/ton"]
[1,2114]
[3,736]
[5,460]
[7,342]
[10,253]
[]
[]
["Minimum yield",{"$f":"3821.2*440^-1.08","v":5.3366765127726392},"ton/ha."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Case 3: No extrusion, open storage, yield is 5.8 ton/ha, Max total cost 55 øre/kgTS"]
["What is max distance by tractor?"]
[]
["Distance field to facility","kr/ton"]
[12,356]
[15,374]
[17,385]
[20,403]
[25,432]
[30,455]
[]
["Max distance is ",{"$f":"0.1796*B27-52.17","v":-51.379760000000005},"km"]
[]
[]
[]
[]
[]
[]
[]
[]
["Case 4: As case 3, when is reload to lorry cheapest?"]
[]
[null,"Tractor","Reload & Lorry"]
["Distance field to facility","kr/ton","kr/ton"]
[17,385,431]
[20,403,437]
[25,432,447]
[30,455,454]
[35,484,466]
[40,514,474]
[]
[]
["Max distance by lorry is:",{"$f":"0.5326*B27-212.63","v":-210.28656000000001},"km"]
["that is, if price is 440 kr/ton, then lorry transport will be too costly, no matter distance."]
[]
[]
["Case 5: As case 4, if grass prices were higher, when is reload cheapest?"]
[]
[]
["X","Cross point","Distance"]
[{"$f":"5.52-1.87","v":3.6499999999999995},{"$f":"399.41-291.92","v":107.49000000000001},{"$f":"B106/A106","v":29.449315068493156}]
[]
["If distance is higher than 29,5 km, reload to lorry is cheapest."]

{"sheet":"Ark1","index":25,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Revenue"]
[]
[]
["Total biogas production"]
[null,null,null,"m3 biogas/year"]
[]
["Methane energy content",null,null,0.6]

{"sheet":"Raw Clover 3 cut","index":26,"n_rows":90,"n_cols":19,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,1,0,18],[59,1,59,2]]}
["Sædskiftegræs 4 slæt","Clover grass 3 cuts"]
["Ajourført 10/11 2017",null,null,"Seeds","N","P","K","Manure","Plastic","Manure spredding","Fertilizer, spred","Sowing","Mowing","Raking","Fine cutting, driving, handling","Watering","watering, moving of","watering pr. ml","Other tasks"]
[null,null,"JB 1-3",9,284,35,{"$f":"262-6","v":256},0,{"$f":"173-18","v":155},0,3,0.5,3,3,3,0,0,0,1]
[null,null,"JB 1-4 + watering",9,299,43,{"$f":"316-6","v":310},0,{"$f":"212-18","v":194},0,3,0.5,3,3,3,1,3,150,1]
[null,null,"JB 5-6",9,289,37,{"$f":"257-6","v":251},0,{"$f":"185-18","v":167},0,3,0.5,3,3,3,0,0,0,1]
[null,null,"JB 1-3+ manure",9,95,0,0,60,{"$f":"173-18","v":155},60,1,0.5,3,3,3,0,0,0,1]
[null,null,"JB 1-4 + manure+ water",9,110,0,0,60,{"$f":"212-18","v":194},60,1,0.5,3,3,3,1,3,150,1]
[null,null,"JB 5-6 + manure + water",9,100,0,0,60,{"$f":"185-18","v":167},60,1,0.5,3,3,3,0,0,0,1]
[]
[null,null,"JB 1-3",-38.5,-6.3,-12,-5,0,-2.2000000000000002,-21,-133,-380,{"$f":"-275*1.15","v":-316.25},{"$f":"-175*0.85","v":-148.75},{"$f":"-714*1.15","v":-821.09999999999991},0,0,0,-500]
[null,null,"JB 1-4 + watering",-38.5,-6.3,-12,-5,0,-2.2000000000000002,-21,-133,-380,{"$f":"-275*1.15","v":-316.25},{"$f":"-175*0.85","v":-148.75},{"$f":"1.15*-807","v":-928.05},-1200,-120,-5,-500]
[null,null,"JB 5-6",-38.5,-6.3,-12,-5,0,-2.2000000000000002,-21,-140,-400,-316.25,-148.75,{"$f":"1.15*-751","v":-863.65},0,0,0,-500]
[null,null,"JB 1-3+ manure",-38.5,-6.3,-12,-5,0,-2.2000000000000002,-21,-133,-380,-316.25,-148.75,{"$f":"1.15*-710","v":-816.49999999999989},0,0,0,-500]
[null,null,"JB 1-4 + manure+ water",-38.5,-6.3,-12,-5,0,-2.2000000000000002,-21,-133,-380,-316.25,-148.75,{"$f":"1.15*-807","v":-928.05},-1200,-120,-5,-500]
[null,null,"JB 5-6 + manure + water",-38.5,-6.3,-12,-5,0,-2.2000000000000002,-23,-140,-400,-316.25,-148.75,{"$f":"1.15*-751","v":-863.65},0,0,0,-500]
[]
[null,1,"JB 1-3",{"$f":"D3*D10","v":-346.5},{"$f":"E3*E10","v":-1789.2},{"$f":"F3*F10","v":-420},{"$f":"G3*G10","v":-1280},{"$f":"H3*H10","v":0},-341,0,-399,-190,-948.75,-446.25,-2463.2999999999997,0,0,0,{"$f":"S3*S10","v":-500}]
[null,2,"JB 1-4 + watering",{"$f":"D4*D11","v":-346.5},-1883.7,-516,-1550,0,-426.8,0,-399,-190,-948.75,-446.25,-2784.1499999999996,-1200,-360,-750,-500]
[null,3,"JB 5-6",-346.5,-1820.7,-444,-1255,0,-367.40000000000003,0,-420,-200,-948.75,-446.25,-2590.9499999999998,0,0,0,-500]
[null,4,"JB 1-3+ manure",-346.5,-598.5,0,0,0,-341,{"$f":"J6*J13","v":-1260},-133,-190,-948.75,-446.25,-2449.4999999999995,0,0,0,-500]
[null,5,"JB 1-4 + manure+ water",-346.5,-693,0,0,0,-426.8,-1260,-133,-190,-948.75,-446.25,-2784.1499999999996,-1200,-360,-750,-500]
[null,6,"JB 5-6 + manure + water",-346.5,-630,0,0,0,-367.40000000000003,-1380,-140,-200,-948.75,-446.25,-2590.9499999999998,0,0,0,-500]
[]
[]
[null,null,null,"kr/time","kapacitet","km/time"]
[null,1,"Tractor dumper",{"$f":"T_Tipvogn","v":-625},{"$f":"Normer!C25","v":35},{"$f":"TractorSpeedRoad","v":25}]
[null,2,"Lorry dumper",{"$f":"L_Dumper","v":-675},{"$f":"LorryDumpCap","v":55},{"$f":"LorrySpeed","v":51.5}]
[]
[]
[null,"Græsensilage kørsilo"]
[null,null,null,null,null,"Udnyttelse"]
[null,"Volume","Højde",3,"meter",3.2]
[null,null,"Længde",50,"meter",45]
[null,null,"Brede",16,"meter",15]
[null,"m3 i alt",null,{"$f":"D32*D33*D34","v":2400},null,{"$f":"F32*F33*F34","v":2160}]
[]
[null,"Pris på anlægget"]
[null,"L -elementer","3x1 meter",-2300,"kr"]
[null,"Bund","m2",-500,"kr"]
[]
[null,"Omkostninger i alt"]
[null,"Bund",null,null,null,{"$f":"D39*D33*D34","v":-400000},"kr."]
[null,"Sider 2x 50+16",null,null,null,{"$f":"(46+D33+D34)*D38","v":-257600},"kr."]
[null,"I alt",null,null,null,{"$f":"F42+F43","v":-657600},"kr."]
[null,"Jordarbejde mm + 10 pct",null,10,null,{"$f":"F44+(F44*D45/100)","v":-723360},"kr."]
[null,"Cover",null,null,null,{"$f":"'Raw data Maize'!G55","v":-2400},"kr."]
[null,"Labour",{"$f":"Tabels!C68","v":"Arbejdstimer"},6,null,{"$f":"D47*timeløn","v":-720},"kr."]
[null,"Yearly costs, 20 yrs",null,null,null,{"$f":"-PMT(Interest,20,F45)+F46+F47","v":-63650.280174069267},"kr./år"]
[null,"Cost per m3",null,null,null,{"$f":"F48/F35","v":-29.467722302809847},"kr/m3"]
[]
[null,"Beregnet densitet af ensileret græs udfra stakhøjde og TS%",null,null,null,{"$f":"(255-(2.7*F52*100)+(6.7*F32))","v":227.84},"kgTS/m3",null,"Density ensiled grass measured"]
[null,"TS % i græs",null,null,null,{"$f":"Ley!C9","v":0.18},null,null,"Lenght of pile/clamp",null,{"$f":"F33","v":45},"m"]
[null,"TS vægt i siloen",null,null,null,{"$f":"F51*F35","v":492134.40000000002},"KgTS",null,"Bottom width",null,{"$f":"D34","v":16},"m"]
[null,"Pris pr. ton TS",null,null,null,{"$f":"F48/F53","v":-0.12933515757904601},"kr.KgTS",null,"Top width under dome",null,{"$f":"F34","v":15},"m"]
[null,null,null,null,null,{"$f":"F49/DensCalcGrass","v":-0.12933515757904601},null,null,"Height under dome",null,3.2,"m",{"$f":"(K54^2/(8*K56))+(K56/2)","v":88.050624999999997}]
[null,"v. TS30% er der 595 kg vådvægt per m3",null,null,null,{"$f":"F49/595*1000","v":-49.525583702201423},"kr/ton WW",null,"Dome height",null,0.32,"m",{"$f":"M55-K56","v":87.730625000000003}]
[null,null,null,null,null,null,null,null,"Area of silage",null,{"$f":"(((K53+K54)/2)*K55)+((M55^2*ACOS(M56/M55))-M56*0.5*K54)","v":52.80116478162595},"m2",{"$f":"((M55^2*ACOS(M56/M55))-M56*0.5*K54)","v":3.2011647816259483}]
[null,null,null,null,null,null,null,null,"Lenght of slide ",null,0.8,"m"]
[null,null,null,null,null,null,null,null,"Weight of slide",null,8.3000000000000007,"ton"]
[null,"Grass Silage Density",null,null,null,null,null,null,"Measured Silage Density in this pile",null,{"$f":"K59/(K57*K58)","v":0.19649187745968724},"ton/m3"]
[null,"Silage Dry Matter ","Silage Density","kgTS/m3"]
[null,"(%)","(kg  fresh weight/cubic metre)"]
[null,18,760,{"$f":"C63*B63*0.01","v":136.80000000000001}]
[null,19,740,{"$f":"C64*B64*0.01","v":140.6}]
[null,20,725,145]
[null,{"$f":"B65+1","v":21},715,150.15]
[null,22,695,152.9]
[null,23,690,158.70000000000002]
[null,24,670,160.80000000000001]
[null,25,665,166.25]
[null,26,650,169]
[null,27,640,172.8]
[null,28,630,176.4]
[null,29,620,179.8]
[null,30,615,184.5]
[null,31,595,184.45000000000002]
[null,32,580,185.6]
[null,33,570,188.1]
[null,34,560,190.4]
[null,35,545,190.75]
[null,36,535,192.6]
[null,37,520,192.4]
[null,38,510,193.8]
[null,39,500,195]
[null,40,485,194]
[null,{"$f":"B85+1","v":41},475,194.75]
[null,{"$f":"B86+1","v":42},460,193.20000000000002]
[null,{"$f":"B87+1","v":43},450,193.5]
[null,{"$f":"B88+1","v":44},440,193.6]
[null,{"$f":"B89+1","v":45},430,193.5]

{"sheet":"Raw data Ley","index":27,"n_rows":90,"n_cols":19,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,1,0,18],[59,1,59,2]]}
["Sædskiftegræs 4 slæt","Ley grass"]
["Ajourført 25-06-2018",null,null,"Seeds","N","P","K","Manure","Plastic","Manure spredding","Fertilizer, spred","Sowing","Mowing","Raking","Fine cutting, driving, handling","Watering","watering, moving of","watering pr. ml","Other tasks"]
[null,null,"JB 1-3",9,284,36,262,0,173,0,3,0.5,4,4,4,0,0,0,1]
[null,null,"JB 1-4 + watering",9,299,44,316,0,212,0,3,0.5,4,4,4,1,3,150,1]
[null,null,"JB 5-6",9,289,38,257,0,185,0,3,0.5,4,4,4,0,0,0,1]
[null,null,"JB 1-3+ manure",9,95,0,0,60,173,60,1,0.5,4,4,4,0,0,0,1]
[null,null,"JB 1-4 + manure+ water",9,110,0,0,60,212,60,1,0.5,4,4,4,1,3,150,1]
[null,null,"JB 5-6 + manure + water",9,100,0,0,60,185,60,1,0.5,4,4,4,0,0,0,1]
[]
[null,null,"JB 1-3",-38,-6.5,-12,-6,0,-2.2000000000000002,-21,-133,-380,-275,-175,-714,0,0,0,-500]
[null,null,"JB 1-4 + watering",-38,-6.5,-12,-6,0,-2.2000000000000002,-21,-133,-380,-275,-175,-807,-1200,-120,-5,-500]
[null,null,"JB 5-6",-38,-6.5,-12,-6,0,-2.2000000000000002,-21,-140,-400,-275,-175,-751,0,0,0,-500]
[null,null,"JB 1-3+ manure",-38,-6.5,-12,-6,0,-2.2000000000000002,-21,-133,-380,-275,-175,-710,0,0,0,-500]
[null,null,"JB 1-4 + manure+ water",-38,-6.5,-12,-6,0,-2.2000000000000002,-21,-133,-380,-275,-175,-807,-1200,-120,-5,-500]
[null,null,"JB 5-6 + manure + water",-38,-6.5,-12,-6,0,-2.2000000000000002,-23,-140,-400,-275,-175,-751,0,0,0,-500]
[]
[null,1,"JB 1-3",{"$f":"D3*D10","v":-342},{"$f":"E3*E10","v":-1846},{"$f":"F3*F10","v":-432},{"$f":"G3*G10","v":-1572},{"$f":"H3*H10","v":0},-380.6,0,-399,-190,-1100,-700,-2856,0,0,0,{"$f":"S3*S10","v":-500}]
[null,2,"JB 1-4 + watering",{"$f":"D4*D11","v":-342},-1943.5,-528,-1896,0,-466.40000000000003,0,-399,-190,-1100,-700,-3228,-1200,-360,-750,-500]
[null,3,"JB 5-6",-342,-1878.5,-456,-1542,0,-407.00000000000006,0,-420,-200,-1100,-700,-3004,0,0,0,-500]
[null,4,"JB 1-3+ manure",-342,-617.5,0,0,0,-380.6,{"$f":"J6*J13","v":-1260},-133,-190,-1100,-700,-2840,0,0,0,-500]
[null,5,"JB 1-4 + manure+ water",-342,-715,0,0,0,-466.40000000000003,-1260,-133,-190,-1100,-700,-3228,-1200,-360,-750,-500]
[null,6,"JB 5-6 + manure + water",-342,-650,0,0,0,-407.00000000000006,-1380,-140,-200,-1100,-700,-3004,0,0,0,-500]
[]
[]
[null,null,null,"kr/time","kapacitet","km/time"]
[null,1,"Tractor dumper",{"$f":"T_Tipvogn","v":-625},{"$f":"Normer!C25","v":35},{"$f":"TractorSpeedRoad","v":25}]
[null,2,"Lorry dumper",{"$f":"L_Dumper","v":-675},{"$f":"LorryDumpCap","v":55},{"$f":"LorrySpeed","v":51.5}]
[]
[]
[null,"Græsensilage kørsilo"]
[null,null,null,null,null,"Udnyttelse"]
[null,"Volume","Højde",3,"meter",3.2]
[null,null,"Længde",50,"meter",45]
[null,null,"Brede",16,"meter",15]
[null,"m3 i alt",null,{"$f":"D32*D33*D34","v":2400},null,{"$f":"F32*F33*F34","v":2160}]
[]
[null,"Pris på anlægget"]
[null,"L -elementer","3x1 meter",-2300,"kr"]
[null,"Bund","m2",-500,"kr"]
[]
[null,"Omkostninger i alt"]
[null,"Bund",null,null,null,{"$f":"D39*D33*D34","v":-400000},"kr."]
[null,"Sider 2x 50+16",null,null,null,{"$f":"(46+D33+D34)*D38","v":-257600},"kr."]
[null,"I alt",null,null,null,{"$f":"F42+F43","v":-657600},"kr."]
[null,"Jordarbejde mm + 10 pct",null,10,null,{"$f":"F44+(F44*D45/100)","v":-723360},"kr."]
[null,"Cover",null,null,null,{"$f":"'Raw data Maize'!G55","v":-2400},"kr."]
[null,"Labour",{"$f":"Tabels!C68","v":"Arbejdstimer"},6,null,{"$f":"D47*timeløn","v":-720},"kr."]
[null,"Yearly costs, 20 yrs",null,null,null,{"$f":"-PMT(Interest,20,F45)+F46+F47","v":-63650.280174069267},"kr./år"]
[null,"Cost per m3",null,null,null,{"$f":"F48/F35","v":-29.467722302809847},"kr/m3"]
[]
[null,"Beregnet densitet af ensileret græs udfra stakhøjde og TS%",null,null,null,{"$f":"(255-(2.7*F52*100)+(6.7*F32))","v":227.84},"kgTS/m3",null,"Density ensiled grass measured"]
[null,"TS % i græs",null,null,null,{"$f":"Ley!C9","v":0.18},null,null,"Lenght of pile/clamp",null,{"$f":"F33","v":45},"m"]
[null,"TS vægt i siloen",null,null,null,{"$f":"F51*F35","v":492134.40000000002},"KgTS",null,"Bottom width",null,{"$f":"D34","v":16},"m"]
[null,"Pris pr. ton TS",null,null,null,{"$f":"F48/F53","v":-0.12933515757904601},"kr.KgTS",null,"Top width under dome",null,{"$f":"F34","v":15},"m"]
[null,null,null,null,null,{"$f":"F49/DensCalcGrass","v":-0.12933515757904601},null,null,"Height under dome",null,3.2,"m",{"$f":"(K54^2/(8*K56))+(K56/2)","v":88.050624999999997}]
[null,"v. TS30% er der 595 kg vådvægt per m3",null,null,null,{"$f":"F49/595*1000","v":-49.525583702201423},"kr/ton WW",null,"Dome height",null,0.32,"m",{"$f":"M55-K56","v":87.730625000000003}]
[null,null,null,null,null,null,null,null,"Area of silage",null,{"$f":"(((K53+K54)/2)*K55)+((M55^2*ACOS(M56/M55))-M56*0.5*K54)","v":52.80116478162595},"m2",{"$f":"((M55^2*ACOS(M56/M55))-M56*0.5*K54)","v":3.2011647816259483}]
[null,null,null,null,null,null,null,null,"Lenght of slide ",null,0.8,"m"]
[null,null,null,null,null,null,null,null,"Weight of slide",null,8.3000000000000007,"ton"]
[null,"Grass Silage Density",null,null,null,null,null,null,"Measured Silage Density in this pile",null,{"$f":"K59/(K57*K58)","v":0.19649187745968724},"ton/m3"]
[null,"Silage Dry Matter ","Silage Density","kgTS/m3"]
[null,"(%)","(kg  fresh weight/cubic metre)"]
[null,18,760,{"$f":"C63*B63*0.01","v":136.80000000000001}]
[null,19,740,{"$f":"C64*B64*0.01","v":140.6}]
[null,20,725,145]
[null,{"$f":"B65+1","v":21},715,150.15]
[null,22,695,152.9]
[null,23,690,158.70000000000002]
[null,24,670,160.80000000000001]
[null,25,665,166.25]
[null,26,650,169]
[null,27,640,172.8]
[null,28,630,176.4]
[null,29,620,179.8]
[null,30,615,184.5]
[null,31,595,184.45000000000002]
[null,32,580,185.6]
[null,33,570,188.1]
[null,34,560,190.4]
[null,35,545,190.75]
[null,36,535,192.6]
[null,37,520,192.4]
[null,38,510,193.8]
[null,39,500,195]
[null,40,485,194]
[null,{"$f":"B85+1","v":41},475,194.75]
[null,{"$f":"B86+1","v":42},460,193.20000000000002]
[null,{"$f":"B87+1","v":43},450,193.5]
[null,{"$f":"B88+1","v":44},440,193.6]
[null,{"$f":"B89+1","v":45},430,193.5]

{"sheet":"Raw Clover","index":28,"n_rows":90,"n_cols":22,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,1,0,18],[59,1,59,2]]}
["Sædskiftegræs/hvidkløvergræs til slæt, 4 slæt","Clover grass 4 cuts"]
["Ajourført 10-11-2017",null,null,"Seeds","N","P","k","Manure","Plastic","Manure spredding","Fertilizer, spred","Sowing","Mowing","Raking","Fine cutting, driving, handling","Watering","watering, moving of","watering pr. ml","Other tasks"]
["Som ley, men med mere såsæd",null,"JB 1-3",20,284,36,262,0,173,0,3,0.5,4,4,4,0,0,0,1]
[null,null,"JB 1-4 + watering",20,299,44,316,0,212,0,3,0.5,4,4,4,1,3,150,1]
[null,null,"JB 5-6",20,289,38,257,0,185,0,3,0.5,4,4,4,0,0,0,1]
[null,null,"JB 1-3+ manure",20,95,0,0,60,173,60,1,0.5,4,4,4,0,0,0,1]
[null,null,"JB 1-4 + manure+ water",20,110,0,0,60,212,60,1,0.5,4,4,4,1,3,150,1]
[null,null,"JB 5-6 + manure + water",20,100,0,0,60,185,60,1,0.5,4,4,4,0,0,0,1]
[]
[null,null,"JB 1-3",-42,-6.3,-12,-5,0,-2.2000000000000002,-21,-133,-380,-275,-175,-714,0,0,0,-500]
[null,null,"JB 1-4 + watering",-42,-6.3,-12,-5,0,-2.2000000000000002,-21,-133,-380,-275,-175,-807,-1200,-120,-5,-500]
[null,null,"JB 5-6",-42,-6.3,-12,-5,0,-2.2000000000000002,-21,-140,-400,-275,-175,-751,0,0,0,-500]
[null,null,"JB 1-3+ manure",-42,-6.3,-12,-5,0,-2.2000000000000002,-21,-133,-380,-275,-175,-710,0,0,0,-500]
[null,null,"JB 1-4 + manure+ water",-42,-6.3,-12,-5,0,-2.2000000000000002,-21,-133,-380,-275,-175,-807,-1200,-120,-5,-500]
[null,null,"JB 5-6 + manure + water",-42,-6.3,-12,-5,0,-2.2000000000000002,-23,-140,-400,-275,-175,-751,0,0,0,-500]
[]
[null,1,"JB 1-3",{"$f":"D3*D10","v":-840},{"$f":"E3*E10","v":-1789.2},{"$f":"F3*F10","v":-432},{"$f":"G3*G10","v":-1310},{"$f":"H3*H10","v":0},-380.6,0,-399,-190,-1100,-700,-2856,0,0,0,{"$f":"S3*S10","v":-500}]
[null,2,"JB 1-4 + watering",{"$f":"D4*D11","v":-840},-1883.7,-528,-1580,0,-466.40000000000003,0,-399,-190,-1100,-700,-3228,-1200,-360,-750,-500]
[null,3,"JB 5-6",-840,-1820.7,-456,-1285,0,-407.00000000000006,0,-420,-200,-1100,-700,-3004,0,0,0,-500]
[null,4,"JB 1-3+ manure",-840,-598.5,0,0,0,-380.6,{"$f":"J6*J13","v":-1260},-133,-190,-1100,-700,-2840,0,0,0,-500]
[null,5,"JB 1-4 + manure+ water",-840,-693,0,0,0,-466.40000000000003,-1260,-133,-190,-1100,-700,-3228,-1200,-360,-750,-500]
[null,6,"JB 5-6 + manure + water",-840,-630,0,0,0,-407.00000000000006,-1380,-140,-200,-1100,-700,-3004,0,0,0,-500]
[]
[]
[null,null,null,"kr/time","kapacitet","km/time",null,null,"Fra Mogens Kjeldal  okt 2016"]
[null,1,"Tractor dumper",{"$f":"T_Tipvogn","v":-625},{"$f":"Normer!C25","v":35},{"$f":"TractorSpeedRoad","v":25}]
[null,2,"Lorry dumper",{"$f":"L_Dumper","v":-675},{"$f":"LorryDumpCap","v":55},{"$f":"LorrySpeed","v":51.5}]
[]
[null,null,null,null,null,null,null,null,"Traktor m frontskårlægger og snittevogn",null,null,null,"Skårlægning og opsamlervogn",null,null,null,"Skårlægning og finsnitning"]
[null,"Græsensilage kørsilo",null,null,null,null,null,null,"Arbejdsbredde",3,"m",null,"Arbejdsbredde",12,"m",null,"Arbejdsbredde",12,"m",null,null,"Priserne virker meget høje"]
[null,null,null,null,null,"Udnyttelse",null,null,"hastighed ",10,"km/h",null,"hastighed ",10,"km/h",null,"hastighed ",10,"km/h"]
[null,"Volume","Højde",3,"meter",3.2,null,null,"faktor",0.7,null,null,"faktor",0.6,null,null,"faktor",0.6]
[null,null,"Længde",50,"meter",45,null,null,"kapacitet",{"$f":"+J30*J31*J32/10","v":2.1},"ha/h",null,"kapacitet",{"$f":"+N30*N31*N32/10","v":7.2},"ha/h",null,"kapacitet",{"$f":"+R30*R31*R32/10","v":7.2},"ha/h"]
[null,null,"Brede",16,"meter",15,null,null,"timepris",1800,"kr/time",null,"timepris",1800,"kr/time",null,"timepris",1800,"kr/time"]
[null,"m3 i alt",null,{"$f":"D32*D33*D34","v":2400},null,{"$f":"F32*F33*F34","v":2160},null,null,"hektarpris",{"$f":"+J34/J33","v":857.14285714285711},"kr",null,"hektarpris",{"$f":"+N34/N33","v":250},"kr/ha",null,"hektarpris",{"$f":"+R34/R33","v":250},"kr/ha"]
[]
[null,"Pris på anlægget",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kan en finsnitter ikke skårlægge?"]
[null,"L -elementer","3x1 meter",-2300,"kr"]
[null,"Bund","m2",-500,"kr"]
[]
[null,"Omkostninger i alt",null,null,null,null,null,null,"Omlæsning fra traktor",null,null,null,"Opsamling"]
[null,"Bund",null,null,null,{"$f":"D39*D33*D34","v":-400000},"kr.",null,"kapacitet",{"$f":"J33","v":2.1},"ha/h",null,"Arbejdsbredde",12,"m",null,"Arbejdsbredde",12,"m"]
[null,"Sider 2x 50+16",null,null,null,{"$f":"(46+D33+D34)*D38","v":-257600},"kr.",null,"timepris",400,"kr/time",null,"hastighed ",5,"km/h",null,"hastighed ",8,"km/h"]
[null,"I alt",null,null,null,{"$f":"F42+F43","v":-657600},"kr.",null,"hektarpris",{"$f":"+J43/J42","v":190.47619047619048},"kr/ha",null,"faktor",0.5,null,null,"faktor",0.5]
[null,"Jordarbejde mm + 10 pct",null,10,null,{"$f":"F44+(F44*D45/100)","v":-723360},"kr.",null,null,null,null,null,"kapacitet",{"$f":"+N42*N43*N44/10","v":3},"ha/h",null,"kapacitet",{"$f":"+R42*R43*R44/10","v":4.8},"ha/h"]
[null,"Cover",null,null,null,{"$f":"'Raw data Maize'!G55","v":-2400},"kr.",null,null,null,null,null,"timepris",1600,"kr/time",null,"timepris",2700,"kr/time"]
[null,"Labour",{"$f":"Tabels!C68","v":"Arbejdstimer"},6,null,{"$f":"D47*timeløn","v":-720},"kr.",null,null,null,null,null,"hektarpris",{"$f":"+N46/N45","v":533.33333333333337},"kr",null,"hektarpris",{"$f":"+R46/R45","v":562.5},"kr"]
[null,"Yearly costs, 20 yrs",null,null,null,{"$f":"-PMT(Interest,20,F45)+F46+F47","v":-63650.280174069267},"kr./år"]
[null,"Cost per m3",null,null,null,{"$f":"F48/F35","v":-29.467722302809847},"kr/m3"]
[]
[null,"Beregnet densitet af ensileret græs udfra stakhøjde og TS%",null,null,null,{"$f":"(255-(2.7*F52*100)+(6.7*F32))","v":227.84},"kgTS/m3"]
[null,"TS % i græs",null,null,null,{"$f":"Ley!C9","v":0.18}]
[null,"TS vægt i siloen",null,null,null,{"$f":"F51*F35","v":492134.40000000002},"KgTS",null,null,null,null,null,"kapacitet",{"$f":"N45","v":3},"ha/h",null,"Arbejdsbredde",{"$f":"+M53","v":"kapacitet"},"m"]
[null,"Pris pr. ton TS",null,null,null,{"$f":"F48/F53","v":-0.12933515757904601},"kr.KgTS",null,null,null,null,null,"timepris",400,"kr/time",null,"hastighed ",8,"km/h"]
[null,null,null,null,null,{"$f":"F49/DensCalcGrass","v":-0.12933515757904601},null,null,null,null,null,null,"hektarpris",{"$f":"+N54/N53","v":133.33333333333334},"kr",null,"faktor",0.5]
[null,"v. TS30% er der 595 kg vådvægt per m3",null,null,null,{"$f":"F49/595*1000","v":-49.525583702201423},"kr/ton WW",null,null,null,null,null,null,null,null,null,"kapacitet",{"$f":"R45","v":4.8},"ha/h"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"timepris",300,"kr/time"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hektarpris",{"$f":"+R57/R56","v":62.5},"kr/ha",null,{"$f":"R58+R47","v":625}]
[]
[null,"Grass Silage Density",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Den sidste her vil jeg gerne regne efter. Jeg er i tvivl om hvordan han har regnet her."]
[null,"Silage Dry Matter ","Silage Density","kgTS/m3",null,null,null,null,null,null,null,null,null,null,null,null,"Det burde være prisen for aflæsning af græsset for traktor. Gennemgå evt med Henning og Hennings rapport"]
[null,"(%)","(kg  fresh weight/cubic metre)"]
[null,18,760,{"$f":"C63*B63*0.01","v":136.80000000000001}]
[null,19,740,{"$f":"C64*B64*0.01","v":140.6}]
[null,20,725,145]
[null,{"$f":"B65+1","v":21},715,150.15]
[null,22,695,152.9]
[null,23,690,158.70000000000002]
[null,24,670,160.80000000000001]
[null,25,665,166.25]
[null,26,650,169,null,"Density ensiled grass measured",null,{"$f":"F33","v":45},"m"]
[null,27,640,172.8,null,"Lenght of pile/clamp",null,{"$f":"D34","v":16},"m"]
[null,28,630,176.4,null,"Bottom width",null,{"$f":"F34","v":15},"m"]
[null,29,620,179.8,null,"Top width under dome",null,3.2,"m",{"$f":"(H73^2/(8*H75))+(H75/2)","v":88.050624999999997}]
[null,30,615,184.5,null,"Height under dome",null,0.32,"m",{"$f":"J74-H75","v":87.730625000000003}]
[null,31,595,184.45000000000002,null,"Dome height",null,{"$f":"(((H72+H73)/2)*H74)+((J74^2*ACOS(J75/J74))-J75*0.5*H73)","v":52.80116478162595},"m2",{"$f":"((J74^2*ACOS(J75/J74))-J75*0.5*H73)","v":3.2011647816259483}]
[null,32,580,185.6,null,"Area of silage",null,0.8,"m"]
[null,33,570,188.1,null,"Lenght of slide ",null,8.3000000000000007,"ton"]
[null,34,560,190.4,null,"Weight of slide",null,{"$f":"H78/(H76*H77)","v":0.19649187745968724},"ton/m3"]
[null,35,545,190.75,null,"Measured Silage Density in this pile"]
[null,36,535,192.6]
[null,37,520,192.4]
[null,38,510,193.8]
[null,39,500,195]
[null,40,485,194]
[null,{"$f":"B85+1","v":41},475,194.75]
[null,{"$f":"B86+1","v":42},460,193.20000000000002]
[null,{"$f":"B87+1","v":43},450,193.5]
[null,{"$f":"B88+1","v":44},440,193.6]
[null,{"$f":"B89+1","v":45},430,193.5]

{"sheet":"Raw data Maize","index":29,"n_rows":92,"n_cols":25,"rows_kept":92,"cut":false,"hidden":false,"merged":[[1,0,1,19]]}
[null,"Sidst opdateret : Farmtal online: Majs til Helsæd: 10-11-2017"]
["Maize"]
[null,null,"Seeds","N","P","K","Manure","Weeds","Plastic","Ploughing","Spread manure","Fertilizer ","Seed bed harrowing","Seeding","Rolling","Spread pesticide","Irrigation","Irrigation, moving of","Irrigation pr. ml","Other tasks","Cutting and transport"]
[1,"JB 1-3",2,171,36,151,null,1,153,1,null,1,1,1,1,2,null,null,null,1]
[2,"JB 1-4 m. vanding",2,187,39,165,null,1,169,1,null,1,1,1,1,2,1,2,70,1]
[3,"JB 5-6",2,160,39,144,null,1,168,1,null,1,1,1,1,2,null,null,null,1]
[1,"JB 1-3",2,30,15,null,3200,1,153,1,45,null,1,1,1,2,null,null,null,1]
[2,"JB 1-4 m. vanding",2,30,15,null,3500,1,169,1,50,null,1,1,1,2,1,2,70,1]
[3,"JB 5-6",2,30,15,null,2900,1,168,1,41,null,1,1,1,2,null,null,null,1]
[]
["Enhedspris uden husdyrgødning:"]
[1,"JB 1-3",-800,-6.3,-12,-5,null,-440,-2.2000000000000002,-608,null,-133,-152,-475,-165,-175,null,null,null,-500,-1700]
[2,"JB 1-4 m. vanding",-800,-6.3,-12,-5,null,-440,-2.2000000000000002,-608,null,-133,-152,-475,-165,-175,-1200,-120,-5,-500,-1785]
[3,"JB 5-6",-800,-6.3,-12,-5,null,-440,-2.2000000000000002,-675,null,-140,-160,-500,-165,-175,null,null,null,-500,-1777]
["Enhedspris med husdyrgødning:"]
[1,"JB 1-3",-800,-6.3,-12,-5,null,-440,-2.2000000000000002,-608,-20,null,-152,-475,-165,-175,null,null,null,-500,-1700]
[2,"JB 1-4 m. vanding",-800,-6.3,-12,-5,null,-440,-2.2000000000000002,-608,-20,null,-152,-475,-165,-175,-1200,-120,-5,-500,-1785]
[3,"JB 5-6",-800,-6.3,-12,-5,null,-440,-2.2000000000000002,-675,-22,null,-160,-500,-165,-175,null,null,null,-500,-1777]
[]
[]
[1,{"$f":"'Raw data Beets'!B18","v":"JB 1-3"},{"$f":"C4*C12","v":-1600},-1077.3,-432,-755,0,-440,-336.6,-608,0,-133,-152,-475,-165,-350,0,0,0,-500,{"$f":"U12","v":-1700}]
[2,"JB 1-4, water",-1600,-1178.0999999999999,-468,-825,0,-440,-371.8,-608,0,-133,-152,-475,-165,-350,-1200,-240,-350,-500,{"$f":"U13","v":-1785}]
[3,{"$f":"'Raw data Beets'!B20","v":"JB 5-6"},-1600,-1008,-468,-720,0,-440,-369.6,-675,0,-140,-160,-500,-165,-350,0,0,0,-500,{"$f":"U14","v":-1777}]
[4,"JB 1-3, manure",{"$f":"C7*C16","v":-1600},-189,-180,0,0,-440,-336.6,-608,-900,0,-152,-475,-165,-350,0,0,0,-500,{"$f":"U16","v":-1700}]
[5,"JB 1-4, man, water",-1600,-189,-180,0,0,-440,-371.8,-608,-1000,0,-152,-475,-165,-350,-1200,-240,-350,-500,{"$f":"U17","v":-1785}]
[6,"JB 5-6, manure",-1600,-189,-180,0,0,-440,-369.6,-675,-902,0,-160,-500,-165,-350,0,0,0,-500,{"$f":"U18","v":-1777}]
[]
[]
[null,null,"kr/time","kapacitet","km/time"]
[1,"Tractor dumper",{"$f":"T_Tipvogn","v":-625},{"$f":"Normer!C25","v":35},{"$f":"TractorSpeedRoad","v":25}]
[2,"Lorry dumper",{"$f":"L_Dumper","v":-675},{"$f":"LorryDumpCap","v":55},{"$f":"LorrySpeed","v":51.5}]
[]
[null,null,"Kapacitet","kr./m3"]
[1,"Clamp Silo",1890,{"$f":"G59","v":-33.677396917496971}]
[2,"Pile",480,{"$f":"S54","v":-4.3849999999999998}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"balleensilering er ikke godt til helsæd"]
[null,null,"Majsensilage kørsilo med enkeltsider",null,null,null,null,null,null,null,"Stor siloposer",null,null,null,null,"Markstak til majs over 28% TS"]
[null,null,null,null,null,null,"Udnyttelse",null,null,null,null,null,null,null,null,"Majshelsæd markstak",null,null,"Markstak placeres oftest hvor afgrøden blev høstet"]
[null,null,"Volume","Højde",3,"meter",2.8]
[null,null,null,"Længde",50,"meter",45,null,null,null,null,null,null,null,null,"Volumen","Længde",null,40,"m"]
[null,null,null,"Brede",16,"meter",15,null,null,null,null,null,null,null,null,null,"bredde",null,"10m-8m"]
[null,null,"m3 i alt",null,{"$f":"E39*E40*E41","v":2400},null,{"$f":"G39*G40*G41","v":1889.9999999999998},null,null,null,null,null,null,null,null,null,"Tværsnitsareal",null,12,"m2","højde 1.5 m"]
[null,null,"m2 plastik + 20%",null,{"$f":"E40*E41*1.2","v":960},null,null,null,null,null,null,null,null,null,null,"m3 i alt",null,null,{"$f":"S40*S42","v":480},"m3"]
[]
[null,null,"Pris på anlægget"]
[null,null,"L -elementer","3x1 meter",2300,"kr",null,null,null,null,null,null,null,null,null,"Underfolie",null,null,-540,"Kr.","Rulle på 12x50m"]
[null,null,"Bund","m2",500,"kr",null,null,null,null,null,null,null,null,null,"Topfolie",null,null,-1200,"Kr.","Rulle på 12x50m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overdækningsnet",null,null,{"$f":"-(4*1140)/10","v":-456},"Kr.","holdbarhed 10 år"]
[null,null,"Omkostninger i alt",null,null,null,null,null,null,null,null,null,null,null,null,"Dæksider",null,null,{"$f":"-1200/10","v":-120},"kr.","holdbarhed 10 år"]
[null,null,"Bund",null,null,null,{"$f":"-E47*E40*E41","v":-400000},null,null,null,null,null,null,null,null,"Tildækning",null,null,{"$f":"0.32*(timeløn/60)*S43","v":-307.2},"kr.","Hvert år "]
[null,null,"Sider 2x 50+16",null,null,null,{"$f":"-(46+E40+E41)*E46","v":-257600},null,null,null,null,null,null,null,null,"Ilægning",null,null,null,null,"2 gummigeder, en til tilkørsel, en til pakning "]
[null,null,"I alt",null,null,null,{"$f":"G50+G51","v":-657600}]
[null,null,"Jordarbejde mm + 10 pct",null,10,null,{"$f":"G52+(G52*E53/100)","v":-723360},"kr.",null,null,null,null,null,null,null,"Samlet årlig omkostning",null,null,{"$f":"S46+S47+(S48/10)+(S49/10)+S50","v":-2104.7999999999997},"kr."]
[null,null,"Coverplastic pris",null,null,null,-2.5,"kr./m2",null,null,null,null,null,null,null,"Omkostning per m3 ensilage",null,null,{"$f":"S53/S43","v":-4.3849999999999998},"Kr./m3"]
[null,"Årlige omkostninger","Cover",null,null,null,{"$f":"G54*E43","v":-2400},"kr."]
[null,"Årlige omkostninger","Labour for covering",null,null,6,{"$f":"F56*timeløn","v":-720},"kr.",null,null,null,null,null,null,null,"Tab fra markstak: Farmtest nr. 63 Ensilering i storpose kontra markstak."]
[null,null,"Levetid silo ifølge SKAT",null,null,null,20,"år",null,null,null,null,null,null,null,"Ensilering i markstak gav 2.6% tab i totalmængde. Lagret fra nov-juli og udtaget fra juli-sep. Dvs. 9-11 mdr lagring"]
[null,null,"Årlig omkostning",null,null,null,{"$f":"-PMT(Interest,G57,G53)+G55+G56","v":-63650.280174069267},"kr/år",null,null,null,null,null,null,null,"En m fra udtagningsfladen er %TS uændret efter udtagning. Selve udtagningsfladen er 20% lavere TS "]
[null,null,null,null,null,null,{"$f":"G58/G42","v":-33.677396917496971},"kr/m3",null,null,null,null,null,null,null,"komprimering 283 kgTs/m3"]
[]
[null,null,"Silage Density",null,{"$f":"Maize!H31","v":0.19054455139496207},"tons/m3",{"$f":"G59/E61","v":-176.74290170433804},"kr/ton",null,null,null,null,null,null,null,"Ilægning: Brug tallene fra farmtal online om transport og ilægning. Den må være det samme for køresilo/plansilo og markstak"]
[null,null,"TS % i græs",null,{"$f":"DMMaize","v":0.34},null,{"$f":"G59/(E61*E62)","v":-519.83206383628828},"kr/tonTS"]
[null,null,null,null,null,null,{"$f":"G62/1000","v":-0.51983206383628833},"kr/kgTS"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Bunker Silo with or without Rounded Top Surface"]
[]
[null,null,"=","=","=","=","="]
[null,null,"Length of Silage Removed (feet)=",null,null,null,3]
[null,null,"Bottom Width of Bunker (feet) =",null,null,null,{"$f":"G41","v":15}]
[null,null,"Silage Depth-Measured from Floor to Bottom of Domed Silage (ft) =",null,null,null,{"$f":"G39","v":2.8}]
[null,null,"Dome Height  above Silage Depth = Maximum silage height minus Pile Depth.",null,null,null,3]
[null,null,"       Use Dome Height = 0.01 when silage is level on top."]
[null,null,"Top Width Measured at Bottom of Domed Silage (feet) =",null,null,null,14]
[null,null,"Bunker Silo Results"]
[null,null,"-------------------------------------------------------------------","------------","-------------","------------","---------------------------"]
[null,null,"Calculated Volume of Feed Removed (cu. feet) =",null,null,null,{"$f":"+G88+G92","v":208.8093281771701}]
[null,null,"Average Density of Stored Silage (As Fed) (lbs AF/cu ft) =",null,null,null,{"$f":"+G36/G82","v":0}]
[null,null,"Average Dry Matter Density of Stored Silage  (lbs DM/cu ft) =",null,null,null,{"$f":"+G83*(100-G37)/100","v":0}]
[null,null,"Feedout Rate (inches per day) =",null,null,null,{"$f":"+G74*12/G38","v":{"$error":"#VALUE!"}}]
[null,null,"-------------------------------------------------------------------","------------","-------------","------------","---------------------------"]
[null,null,"Area Within Bunker Walls (sq ft) =",null,null,null,{"$f":"((+G75+G79)/2)*G76","v":40.599999999999994}]
[null,null,"Volume (cu ft)of silage below the silage dome =",null,null,null,{"$f":"+G74*G87","v":121.79999999999998}]
[null,null,"Radius of Silage Dome. (ft)",null,null,null,{"$f":"(G79*G79/(8*G77))+G77/2","v":9.6666666666666661}]
[null,null,"Radius minus Dome Height (ft) =",null,null,null,{"$f":"+G89-G77","v":6.6666666666666661}]
[null,null,"Cross section area (sq ft) of silage in the silage dome =",null,null,null,{"$f":"(+G89^2)*(ACOS(+G90/G89))-(+G90*SQRT((2*G77*G89)-G77^2))","v":29.003109392390037}]
[null,null,"Volume (cu ft) of silage in the silage dome =",null,null,null,{"$f":"G91*G74","v":87.009328177170119}]

{"sheet":"Bulk Density Tables ","index":30,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Silage Bulk Density Tables",null,null,null,null,null,"Silage Bulk Density Tables"]
[]
["Grass Silage Density",null,null,"Maize Silage Density",null,null,"Whole Crop Silage Density",null,null,"Whole Crop Silage Density Cont."]
["Silage Dry Matter ","Silage Density",null,"Silage Dry Matter ","Silage Density",null,"Silage Dry Matter "," Silage Density",null,"Silage Dry Matter "," Silage Density"]
["(%)","(kg  fresh weight/cubic metre)",null,"(%)","(kg  fresh weight/cubic metre)",null,"(%)","(kg  fresh weight/cubic metre)",null,"(%)","(kg  fresh weight/cubic metre)"]
[18,760,null,25,648,null,35,607,null,53,567]
[19,740,null,26,643,null,36,605,null,54,565]
[20,725,null,27,638,null,37,603,null,55,563]
[{"$f":"A9+1","v":21},715,null,28,633,null,38,600,null,56,561]
[22,695,null,29,628,null,39,598,null,57,559]
[23,690,null,30,623,null,40,596,null,58,556]
[24,670,null,31,618,null,41,594,null,59,554]
[25,665,null,32,613,null,42,592,null,60,552]
[26,650,null,33,608,null,43,589,null,61,550]
[27,640,null,34,603,null,44,587,null,62,548]
[28,630,null,35,598,null,45,585,null,63,545]
[29,620,null,null,null,null,46,583,null,64,543]
[30,615,null,null,null,null,47,581,null,65,541]
[31,595,null,null,null,null,48,578,null,66,539]
[32,580,null,null,null,null,49,576,null,67,537]
[33,570,null,null,null,null,50,574,null,68,534]
[34,560,null,null,null,null,51,572,null,69,532]
[35,545,null,null,null,null,52,570,null,70,530]
[36,535]
[37,520]
[38,510]
[39,500]
[40,485]
[41,475]
[42,460]
[43,450]
[44,440]
[45,430]

{"sheet":"Silage loss","index":31,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Silage storage loss"]
[]
["Removal rate"]
["inch","ca. cm"]
[3,"8 cm/day"]
[6,"15 cm/day"]
[9,"23 cm/day"]
[]
[]
[null,"8 cm"]

{"sheet":"transporteksempler","index":32,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[4,3,4,6],[4,1,4,2]]}
[]
[]
["Halm og forksellige balletyper"]
[]
[null,"Traktor",null,"Lastbil"]
[null,"Bigballer","Flade","Bigballer","Flade","Tunge","Briketter"]
["Vægt",550,500,550,500,900]
["Antal ",24,36,24,36,24,null,null,"baller"]
["Ton/tur",{"$f":"B7/1000*B8","v":13.200000000000001},{"$f":"C7/1000*C8","v":18},{"$f":"D7/1000*D8","v":13.200000000000001},{"$f":"E7/1000*E8","v":18},{"$f":"F7/1000*F8","v":21.6},22,null,"ton/tur"]
["Gns hast",25,25,52,52,52,52,null,"km/t"]
["Timepris",550,550,625,625,625,625,null,"Kr/t"]
["kr/km",{"$f":"B11/B10","v":22},22,12.01923076923077,12.01923076923077,12.01923076923077,12.01923076923077,null,"kr/km"]
["kr/ton/km",{"$f":"B12/B9","v":1.6666666666666665},1.2222222222222223,0.91054778554778548,0.66773504273504281,0.55644586894586889,0.54632867132867136]

{"sheet":"Ark2","index":33,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Efterafgrøder"]
[]
["udbytte 1 ton TS/ha"]
["høstpris 750 kr/ha"]
["Frisk materiale koster 75 kr ved 10% TS"]
[]
["fra kortlægningsrapporten"]
[]
[]
["Dybstrøelse, se også Thorsø Biogas rapport inde i biogasanlægsmappen"]

{"sheet":"Beregnignsark","index":34,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,9,0,11],[1,13,1,15]]}
["Beregningsark",null,null,null,null,null,null,null,null,"Cost (kr./ton)",null,null,null,"5 km","10 km","15 km","5 km","10 km","20 km"]
[null,"Yield","Yield/ha","DM%","DM ton","VS%","VS ton","m3CH4/tVS","m3 CH4","Production","Storage","Pretreatment","Losses","Transport to facility",null,null,"kr/m3","kr/m3","kr/m3"]
["Straw",{"$f":"StrawYield","v":676},{"$f":"Yieldperha","v":3.38},{"$f":"Straw!C7","v":0.89},{"$f":"D3*B3","v":601.64},{"$f":"VS","v":0.86},{"$f":"F3*B3","v":581.36},{"$f":"MetanHvedehalm","v":230},{"$f":"H3*G3","v":133712.80000000002},{"$f":"'Results -straw'!B21","v":-117.53727810650888},{"$f":"'Results -straw'!B22+'Results -straw'!B23","v":0},{"$f":"'Results -straw'!B25","v":0},null,-106,-122,-138,{"$f":"((J3+K3+L3+N3)*B3)/I3","v":-1.1301176850682955},{"$f":"((J3+K3+L3+O3)*B3)/I3","v":-1.211007472732603},{"$f":"((J3+K3+L3+P3)*B3)/I3","v":-1.2918972603969103}]
["Rape straw",{"$f":"RapeYield","v":650},{"$f":"'Rape straw'!C6","v":3.25},{"$f":"'Rape straw'!C7","v":0.89},578.5,{"$f":"RapeVS","v":0.81599999999999995},530.4,{"$f":"MethaneRape","v":310},164424,{"$f":"'Results rape straw'!B9","v":-194.23076923076923},{"$f":"'Results rape straw'!B10+'Results rape straw'!B11","v":-193.8146462305991},{"$f":"'Results rape straw'!B13","v":0},null,-148,-157,-166,{"$f":"((J4+K4+L4+N4)*B4)/I4","v":-2.1190916170990208},{"$f":"((J4+K4+L4+O4)*B4)/I4","v":-2.1546703647271044},{"$f":"((J4+K4+L4+P4)*B4)/I4","v":-2.1902491123551879}]
["Meadow grass",{"$f":"MeaYield","v":66},{"$f":"MeaYieldHa","v":5.5},{"$f":"MeaDM","v":0.8},52.800000000000004,{"$f":"MeaVS","v":0.68},44.88,{"$f":"MetanEng","v":250},11220,{"$f":"'Results  meadow grass'!B12","v":-375.81818181818181},{"$f":"'Results  meadow grass'!B13","v":0},{"$f":"'Results  meadow grass'!B15","v":0},null,-73,-103,-132,{"$f":"((J5+K5+L5+N5)*B5)/I5","v":-2.6401069518716578},{"$f":"((J5+K5+L5+O5)*B5)/I5","v":-2.8165775401069517},{"$f":"((J5+K5+L5+P5)*B5)/I5","v":-2.9871657754010696}]
["Beets",{"$f":"BeetYield","v":4300},{"$f":"BeetFieldYield","v":86},{"$f":"BeetTS","v":0.223},958.9,{"$f":"BeetVS","v":0.20070000000000002},863.0100000000001,{"$f":"Normer!Y27","v":380},327943.80000000005,{"$f":"'Results beets'!B6+'Results beets'!B7","v":-124.75581395348837},{"$f":"'Results beets'!B8","v":-11.377034333847106},{"$f":"'Results beets'!B10","v":-16.429198966408268},null,-33,-37,-41,{"$f":"((J6+K6+L6+N6)*B6)/I6","v":-2.4330900696738227},{"$f":"((J6+K6+L6+O6)*B6)/I6","v":-2.4855380805830087},{"$f":"((J6+K6+L6+P6)*B6)/I6","v":-2.5379860914921952}]
["Maize",{"$f":"MaWetWeight","v":1180.8},{"$f":"Maize!C7","v":36.9},{"$f":"DMMaize","v":0.34},401.47200000000004,{"$f":"Maize!C10","v":0.32300000000000001},381.39839999999998,{"$f":"Normer!Y28","v":360},137303.424,{"$f":"'Results Maize'!B12+'Results Maize'!B13","v":-208.75135501355015},{"$f":"'Results Maize'!B15","v":-194.4871616857067},null,null,-22,-45,-67,{"$f":"((J7+K7+L7+N7)*B7)/I7","v":-3.6570219874377088},{"$f":"((J7+K7+L7+O7)*B7)/I7","v":-3.854820405050368},{"$f":"((J7+K7+L7+P7)*B7)/I7","v":-4.0440188914624766}]
["Ley",{"$f":"Leyyield","v":1500},{"$f":"Ley!C7","v":30},{"$f":"Ley!C9","v":0.18},270,{"$f":"Ley!C12","v":0.16200000000000001},243,{"$f":"Normer!Y22","v":320},77760,{"$f":"'Results Ley'!C10+'Results Ley'!C11","v":-411.20476190476188},{"$f":"'Results Ley'!C13+'Results Ley'!C16","v":-103.97037250935627}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"includes 5 km transport to farm"]